/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : ry-vue

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 09/12/2022 16:12:44
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table`  (
  `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '表描述',
  `sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联子表的表名',
  `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '子表关联的外键名',
  `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '生成功能作者',
  `gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
  `gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
  `options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '其它生成选项',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`table_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gen_table
-- ----------------------------
INSERT INTO `gen_table` VALUES (4, 'import_export_task', '导入导出任务', NULL, NULL, 'ImportExportTask', 'crud', 'com.ruoyi.yys', 'importExport', 'task', '导入导出任务', 'xinyin', '0', '/', '{\"parentMenuId\":\"2007\"}', 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00', NULL);
INSERT INTO `gen_table` VALUES (5, 'import_export_template', '导入导出模板', NULL, NULL, 'ImportExportTemplate', 'crud', 'com.ruoyi.yys', 'importExport', 'template', '导入导出模板', 'xinyin', '0', '/', '{\"parentMenuId\":\"2007\"}', 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26', NULL);
INSERT INTO `gen_table` VALUES (6, 'jdbc_config', '数据库连接配置', NULL, NULL, 'JdbcConfig', 'crud', 'com.ruoyi.yys', 'importExport', 'jdbcConfig', '数据库连接配置', 'xinyin', '0', '/', '{\"parentMenuId\":\"2007\"}', 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51', NULL);

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column`  (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '列类型',
  `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
  `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典类型',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 115 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
INSERT INTO `gen_table_column` VALUES (66, '4', 'id', '主键', 'varchar(38)', 'String', 'id', '1', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (67, '4', 'isdelete', '是否逻辑删除（  1：删除  0：正常）', 'int(11)', 'Long', 'isdelete', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (68, '4', 'template_id', '模板id', 'int(11)', 'Long', 'templateId', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (69, '4', 'status', '数据状态', 'varchar(10)', 'String', 'status', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'task_status', 4, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (70, '4', 'op_type', '操作类型', 'varchar(20)', 'String', 'opType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'task_op_type', 5, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (71, '4', 'op_file_name', '操作文件路径+名称', 'varchar(100)', 'String', 'opFileName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 6, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (72, '4', 'op_down_path', '文件下载路径', 'varchar(100)', 'String', 'opDownPath', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (73, '4', 'op_async', '是否异步执行', 'int(11)', 'Long', 'opAsync', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'task_op_async', 8, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (74, '4', 'op_file_type', '操作文件类型 xml、excel、json', 'varchar(20)', 'String', 'opFileType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 9, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (75, '4', 'op_error', '操作异常消息', 'longtext', 'String', 'opError', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'textarea', '', 10, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (76, '4', 'progress', '进度', 'varchar(10)', 'String', 'progress', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 11, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (77, '4', 'execute_time', '执行时间（秒）', 'varchar(20)', 'String', 'executeTime', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 12, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (78, '4', 'remark', '备注', 'text', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 13, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (79, '4', 'create_by', '创建者', 'varchar(100)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 14, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (80, '4', 'create_time', '创建时间', 'varchar(32)', 'String', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 15, 'admin', '2022-12-07 15:19:34', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (81, '4', 'update_by', '修改者', 'varchar(100)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 16, 'admin', '2022-12-07 15:19:35', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (82, '4', 'update_time', '修改时间', 'varchar(32)', 'String', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 17, 'admin', '2022-12-07 15:19:35', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (83, '4', 'system', '系统', 'varchar(30)', 'String', 'system', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 18, 'admin', '2022-12-07 15:19:35', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (86, '5', 'id', '主键', 'bigint(20)', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (87, '5', 'template_type', '模板类型（1：sql模板，2：excel模板）', 'int(11)', 'Long', 'templateType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'template_type', 2, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (88, '5', 'file_path', '模板文件路径', 'varchar(200)', 'String', 'filePath', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (89, '5', 'file_type', '模板文件类型（1：本地文件，2： oss文件）', 'int(11)', 'Long', 'fileType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'template_file_type', 4, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (90, '5', 'dict', '字典映射（标题，列）（json或yaml格式）', 'longtext', 'String', 'dict', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'textarea', '', 5, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (91, '5', 'style', '样式（json或yaml格式）', 'longtext', 'String', 'style', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'textarea', '', 6, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (92, '5', 'remark', '备注', 'text', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 7, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (93, '5', 'isdelete', '是否删除', 'int(11)', 'Long', 'isdelete', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 8, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (94, '5', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 9, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (95, '5', 'create_time', '创建时间', 'varchar(32)', 'String', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 10, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (96, '5', 'update_by', '修改者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 11, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (97, '5', 'update_time', '修改时间', 'varchar(32)', 'String', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 12, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (98, '5', 'jdbc_config_id', '数据库连接配置', 'varchar(32)', 'String', 'jdbcConfigId', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 13, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (99, '5', 'table_name', '表名（导入时的表）', 'varchar(50)', 'String', 'tableName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 14, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 08:48:26');
INSERT INTO `gen_table_column` VALUES (100, '6', 'id', '主键', 'varchar(32)', 'String', 'id', '1', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (101, '6', 'type', '数据库类型', 'varchar(30)', 'String', 'type', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'database_type', 2, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (102, '6', 'ip', 'ip', 'varchar(30)', 'String', 'ip', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (103, '6', 'port', '端口', 'varchar(10)', 'String', 'port', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (104, '6', 'database_name', '数据库名称', 'varchar(30)', 'String', 'databaseName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 5, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (105, '6', 'user_name', '用户名', 'varchar(50)', 'String', 'userName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 6, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (106, '6', 'password', '密码', 'varchar(50)', 'String', 'password', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (107, '6', 'remark', '备注', 'text', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 8, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (108, '6', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 9, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (109, '6', 'create_time', '创建时间', 'varchar(32)', 'String', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 10, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (110, '6', 'update_by', '修改者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 11, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (111, '6', 'update_time', '修改时间', 'varchar(32)', 'String', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 12, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (112, '6', 'isdelete', '是否删除', 'int(11)', 'Long', 'isdelete', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 13, 'admin', '2022-12-07 15:19:35', '', '2022-12-09 09:19:51');
INSERT INTO `gen_table_column` VALUES (113, '4', 'sqls', '导出sql语句', 'longtext', 'String', 'sqls', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'textarea', '', 19, '', '2022-12-07 15:41:50', '', '2022-12-08 17:31:00');
INSERT INTO `gen_table_column` VALUES (114, '4', 'parameters', '参数', 'longtext', 'String', 'parameters', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'textarea', '', 20, '', '2022-12-07 15:41:50', '', '2022-12-08 17:31:00');

-- ----------------------------
-- Table structure for import_export_task
-- ----------------------------
DROP TABLE IF EXISTS `import_export_task`;
CREATE TABLE `import_export_task`  (
  `id` varchar(38) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
  `isdelete` int(11) NULL DEFAULT NULL COMMENT '是否逻辑删除（  1：删除  0：正常）',
  `template_id` int(11) NULL DEFAULT NULL COMMENT '模板id',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '数据状态',
  `op_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作类型 import、export',
  `op_file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作文件路径+名称',
  `op_down_path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文件下载路径',
  `op_async` int(11) NULL DEFAULT NULL COMMENT '是否异步执行(0：false,1：true)',
  `op_file_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作文件类型 xml、excel、json',
  `op_error` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '操作异常消息',
  `progress` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '进度',
  `execute_time` int(11) NULL DEFAULT NULL COMMENT '执行时间（秒）',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '备注',
  `create_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `system` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '系统',
  `sqls` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '导出sql语句',
  `parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '导入导出任务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of import_export_task
-- ----------------------------
INSERT INTO `import_export_task` VALUES ('202212021811307520005DE0E0D320B4', 0, NULL, '-1', 'export', NULL, NULL, 1, NULL, '未获取到模板数据', NULL, 0, NULL, NULL, '2022-12-02 18:11:30', NULL, '2022-12-02 18:11:30', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('2022120218125469300085A31007C4EB', 0, 9, '-1', 'export', 'D:/excelFile/2022/12/02/202212021812547040000E17B0D8EACA.xlsx', NULL, 1, NULL, '未知错误：Sql String must be not blank!', '100%', 0, NULL, NULL, '2022-12-02 18:12:54', NULL, '2022-12-09 08:56:26', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"templateId\":9,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212021814431650005D050E272185', 0, 9, '-3', 'export', 'D:/excelFile/2022/12/02/20221202181443186000BE4214B26414.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:14:43', NULL, '2022-12-07 17:16:52', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('2022120218162667700000C50E3C36C7', 0, 9, '0', 'export', 'D:/excelFile/2022/12/02/20221202181626698000AAA2A73DBCAB.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:16:26', NULL, '2022-12-07 17:17:30', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('202212021824378490000CC3CAC742B8', 0, 9, '-1', 'export', 'D:/excelFile/2022/12/02/20221202182437851000A2DABBEED1DD.xlsx', NULL, 1, NULL, '未知错误：Sql String must be not blank!', '100%', 0, NULL, NULL, '2022-12-02 18:24:37', NULL, '2022-12-09 08:51:30', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"templateId\":9,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212021825344711001BEE5CACE04B', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/20221202182534491200BEE5B774E5BA.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:25:34', NULL, '2022-12-02 18:25:34', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('20221202182700471300C14DC21705D1', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/20221202182700531400EC726B1CBACE.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:27:00', NULL, '2022-12-02 18:27:00', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('20221202182815721500422DB4B422CB', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/202212021828157416008A738CD3A61C.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:28:15', NULL, '2022-12-02 18:28:15', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('202212021828535817000B63E32D1C7E', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/2022120218285362180001ABB33BEB52.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:28:53', NULL, '2022-12-02 18:28:53', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('202212021829549519008A6270DC25D5', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/2022120218295496200000BDE218E5DB.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:29:54', NULL, '2022-12-02 18:29:55', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('20221202183048672000CBB168C4B60B', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/202212021830487830007AD1422CAEA6.xlsx', NULL, 1, NULL, NULL, '100%', 99, NULL, NULL, '2022-12-02 18:30:48', NULL, '2022-12-02 18:32:28', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('20221202183426554000EBA1C3E7DB3C', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/20221202183426585000D28BE1BA66CA.xlsx', NULL, 1, NULL, NULL, '100%', 5, NULL, NULL, '2022-12-02 18:34:26', NULL, '2022-12-02 18:34:32', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('20221202183535506000A6E50A6ADD1B', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/202212021835355670005E2D5D4C0EA1.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:35:35', NULL, '2022-12-02 18:35:35', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('2022120218361726800058076B207C4B', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/20221202183617279000E6ABAA8B3DC8.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:36:17', NULL, '2022-12-02 18:36:17', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('2022120218411118100074AAC7122584', 0, 9, '2', 'export', 'D:/excelFile/2022/12/02/20221202184111241100B848B1CBA0A0.xlsx', NULL, 1, NULL, NULL, '100%', 0, NULL, NULL, '2022-12-02 18:41:11', NULL, '2022-12-02 18:41:11', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', NULL);
INSERT INTO `import_export_task` VALUES ('202212051200108720001BD5C84E8174', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-05 12:00:10', NULL, '2022-12-05 12:00:10', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205120025573000C1EBB006CD3B', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-05 12:00:25', NULL, '2022-12-05 12:00:25', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205130620624000310A2EB412CB', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-05 13:06:20', NULL, '2022-12-05 13:06:20', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('202212051307474350005BEEB8237A51', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-05 13:07:47', NULL, '2022-12-05 13:07:47', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('2022120513103827200002CE20C2DA02', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:10:38', NULL, '2022-12-05 13:14:07', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('202212051310585430002EC0B3C85C80', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:10:58', NULL, '2022-12-05 13:14:07', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('202212051311153640001A3876ABCAD5', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:11:15', NULL, '2022-12-05 13:14:07', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205131233165000EDE4C612AC7D', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:12:33', NULL, '2022-12-05 13:14:07', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205131335426000ACCBB2EA7DA2', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:13:35', NULL, '2022-12-05 13:14:07', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205131355007000DC5DB5E71B41', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:13:55', NULL, '2022-12-05 13:14:07', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205131509432000CEEBE2726CC4', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:15:09', NULL, '2022-12-05 13:15:21', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('202212051315439120000AC2EAE718C3', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '获取数据失败:Sql String must be not blank!', NULL, 0, NULL, NULL, '2022-12-05 13:15:43', NULL, '2022-12-05 13:17:32', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('202212051320151320000DB1DAAC1DAA', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '读取文件数据出错：暂不支持<application/vnd.openxmlformats-officedocument.spreadsheetml.sheet>格式的文件', NULL, 0, NULL, NULL, '2022-12-05 13:20:15', NULL, '2022-12-05 13:20:15', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205132300133000EB7CA1DB3A60', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '读取文件数据出错：暂不支持<application/vnd.openxmlformats-officedocument.spreadsheetml.sheet>格式的文件', NULL, 0, NULL, NULL, '2022-12-05 13:23:00', NULL, '2022-12-05 13:23:00', NULL, NULL, NULL);
INSERT INTO `import_export_task` VALUES ('20221205132545952000E0123215D11D', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, NULL, 36, NULL, NULL, '2022-12-05 13:25:45', NULL, '2022-12-05 13:26:22', NULL, NULL, '{\"fileName\":\"gz_data_copy.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{},\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"tableName\":\"gz_data_copy\",\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"file\":{},\"fileType\":\"xlsx\"}');
INSERT INTO `import_export_task` VALUES ('202212051357104020002054E7EBD46C', 0, NULL, '2', 'import', 'D:/excelFile/2022/12/05/gz_data_copy.xlsx', NULL, 1, 'excel', '读取文件数据出错：文件解析失败：IOException: Stream Closed', NULL, 1, NULL, NULL, '2022-12-05 13:57:10', NULL, '2022-12-05 14:01:05', NULL, NULL, '{\"fileName\":\"gz_data_copy.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{},\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"tableName\":\"gz_data_copy\",\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"file\":{},\"fileType\":\"xlsx\"}');
INSERT INTO `import_export_task` VALUES ('202212051632502120002D1CBA3A0533', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/gz_data_copy.xlsx', NULL, 1, 'excel', '数据入库出错：EmptyFileException: The supplied file was empty (zero bytes long)', NULL, 0, NULL, NULL, '2022-12-05 16:32:50', NULL, '2022-12-05 16:32:50', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"gz_data_copy.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205163334903000CE5EAA25DAA5', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/gz_data_copy.xlsx', NULL, 1, 'excel', '数据入库出错：EmptyFileException: The supplied file was empty (zero bytes long)', NULL, 1, NULL, NULL, '2022-12-05 16:33:34', NULL, '2022-12-05 16:39:51', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"gz_data_copy.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120516400942400068CBB2641BA3', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Attempting to write a row[12] in the range [0,205902] that is already written to disk.', '100%', 172, NULL, NULL, '2022-12-05 16:40:09', NULL, '2022-12-05 16:43:02', 'ylt', 'SELECT * FROM gz_data_copy', '{\"sql\":\"SELECT * FROM gz_data_copy\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120516451665600027BA7ADD8E3C', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Attempting to write a row[12] in the range [0,9900] that is already written to disk.', '100%', 8, NULL, NULL, '2022-12-05 16:45:16', NULL, '2022-12-05 16:45:25', 'ylt', 'SELECT top 10000 * FROM gz_data_copy', '{\"sql\":\"SELECT top 10000 * FROM gz_data_copy\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212051646065580007A02E3E16BB2', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Attempting to write a row[12] in the range [0,9900] that is already written to disk.', '100%', 43, NULL, NULL, '2022-12-05 16:46:06', NULL, '2022-12-05 16:46:49', 'ylt', 'SELECT top 10000 * FROM gz_data_copy', '{\"sql\":\"SELECT top 10000 * FROM gz_data_copy\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212051647089210002B3D3CBD230B', 0, 11, '2', 'export', NULL, NULL, 1, 'excel', NULL, '100%', NULL, NULL, NULL, '2022-12-05 16:47:08', NULL, '2022-12-05 16:48:17', 'ylt', 'SELECT top 10000 * FROM gz_data_copy', '{\"sql\":\"SELECT top 10000 * FROM gz_data_copy\",\"templateId\":\"11\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212051649376220003C0D0A23E8DC', 0, 11, '2', 'export', NULL, NULL, 1, 'excel', NULL, '100%', NULL, NULL, NULL, '2022-12-05 16:49:37', NULL, '2022-12-05 16:52:23', 'ylt', 'SELECT * FROM gz_data_copy', '{\"sql\":\"SELECT * FROM gz_data_copy\",\"templateId\":\"11\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205165445362000CCAA0CBD6E04', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 0, NULL, NULL, '2022-12-05 16:54:45', NULL, '2022-12-05 16:54:55', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205165607273000BDED5DC02558', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 14, NULL, NULL, '2022-12-05 16:56:07', NULL, '2022-12-05 16:56:24', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212051656416440008064B26CCA37', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 40, NULL, NULL, '2022-12-05 16:56:41', NULL, '2022-12-05 16:57:24', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212051705195420006C3BB4625AB2', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 11, NULL, NULL, '2022-12-05 17:05:19', NULL, '2022-12-05 17:05:33', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120517060709200032AB11E451AA', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 118, NULL, NULL, '2022-12-05 17:06:07', NULL, '2022-12-05 17:08:08', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205170948222000100383DA84D8', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 10, NULL, NULL, '2022-12-05 17:09:48', NULL, '2022-12-05 17:10:02', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120517115659200044ADAD72DBBD', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '读取文件数据出错：文件解析失败：IOException: Stream Closed', NULL, 30, NULL, NULL, '2022-12-05 17:11:56', NULL, '2022-12-05 17:12:31', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205171502012000A4075BDA0DEB', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 16, NULL, NULL, '2022-12-05 17:15:02', NULL, '2022-12-05 17:15:21', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"file\":{},\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205172024132000BC8E8D5E73A2', 0, NULL, '2', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', NULL, NULL, NULL, NULL, NULL, '2022-12-05 17:20:24', NULL, NULL, NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"file\":{},\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212051721138930008455EEEBAAC2', 0, NULL, '2', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', NULL, NULL, NULL, NULL, NULL, '2022-12-05 17:21:13', NULL, NULL, NULL, NULL, '{\n	\"tableName\": \"gz_data_copy\",\n	\"fileType\": \"xlsx\",\n	\"fileName\": \"20221205164941383000D8E8A137B04A.xlsx\",\n	\"titleMap\": {\n		\"项目名称\": \"ss_name\",\n		\"维修名称\": \"wx_name\"\n	},\n	\"columnMap\": {\n		\"项目名称\": {\n			\"1\": \"项目1\",\n			\"2\": \"项目2\",\n			\"3\": \"项目3\"\n		},\n		\"维修名称\": {\n			\"1\": \"维修1\",\n			\"2\": \"维修2\",\n			\"3\": \"维修3\"\n		}\n	},\n	\"pageNumber\": 1,\n	\"pageSize\": 10,\n	\"params\": {}\n}');
INSERT INTO `import_export_task` VALUES ('202212051731447030005286BC87EDB0', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', NULL, NULL, NULL, NULL, NULL, '2022-12-05 17:31:44', NULL, NULL, NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205173238822000101876B651EE', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：null', NULL, 12, NULL, NULL, '2022-12-05 17:32:38', NULL, '2022-12-05 17:35:15', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221205173520622000CD0E7C7ACCC1', 0, NULL, '2', 'import', 'D:/excelFile/2022/12/05/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', NULL, NULL, NULL, NULL, NULL, '2022-12-05 17:35:20', NULL, NULL, NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212060852234320004CD33CECD48D', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/06/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 68, NULL, NULL, '2022-12-06 08:52:23', NULL, '2022-12-06 08:53:32', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212060920276520008CC6506EC8AC', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/06/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：获取行数出错：Stream Closed', NULL, 58, NULL, NULL, '2022-12-06 09:20:27', NULL, '2022-12-06 09:21:29', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206092951382000C245AB074E12', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/06/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：IOException: Stream Closed', NULL, 0, NULL, NULL, '2022-12-06 09:29:51', NULL, '2022-12-06 09:29:54', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120609313399300072AE83C43EB8', 0, NULL, '2', 'import', 'D:/excelFile/2022/12/06/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', NULL, '0条', NULL, NULL, NULL, '2022-12-06 09:31:34', NULL, '2022-12-06 09:47:25', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212060933121320000DAB365C7AC4', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, NULL, NULL, NULL, NULL, '2022-12-06 09:33:12', NULL, NULL, NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206093338393000C2883D318848', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, NULL, NULL, NULL, NULL, '2022-12-06 09:33:38', NULL, NULL, NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206094859592000E34BECEBBBCE', 0, NULL, '2', 'import', 'D:/excelFile/2022/12/06/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '100%', 23, NULL, NULL, '2022-12-06 09:48:59', NULL, '2022-12-06 09:49:23', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212060950368930006AB54DACA6C5', 0, NULL, '-1', 'import', 'D:/excelFile/2022/12/06/20221205164941383000D8E8A137B04A.xlsx', NULL, 1, 'excel', '数据入库出错：The supplied file was empty (zero bytes long)', '0条', 0, NULL, NULL, '2022-12-06 09:50:36', NULL, '2022-12-06 09:52:16', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206095502002000E83ABDEB2DA3', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '数据入库出错：主动终止', '25000条', 47, NULL, NULL, '2022-12-06 09:55:02', NULL, '2022-12-06 09:55:49', NULL, NULL, '{\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"20221205164941383000D8E8A137B04A.xlsx\",\"titleMap\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"columnMap\":{\"项目名称\":{\"1\":\"项目1\",\"2\":\"项目2\",\"3\":\"项目3\"},\"维修名称\":{\"1\":\"维修1\",\"2\":\"维修2\",\"3\":\"维修3\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206104902423000B0EC73EC3E44', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Expected a \':\' after a key at 5 [character 6 line 1]', NULL, 13, NULL, NULL, '2022-12-06 10:49:02', NULL, '2022-12-06 10:49:15', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206105039875000A8EECC8CCA08', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Expected a \':\' after a key at 5 [character 6 line 1]', NULL, 0, NULL, NULL, '2022-12-06 10:50:39', NULL, '2022-12-06 10:50:39', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206105051057000127E38AA820D', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Expected a \':\' after a key at 5 [character 6 line 1]', NULL, 47, NULL, NULL, '2022-12-06 10:50:51', NULL, '2022-12-06 10:51:38', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206105139759000A8DD1E042AB5', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Expected a \':\' after a key at 5 [character 6 line 1]', NULL, 34, NULL, NULL, '2022-12-06 10:51:39', NULL, '2022-12-06 10:52:14', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206105216191100CBA7BBE3D4E8', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:Expected a \':\' after a key at 5 [character 6 line 1]', NULL, 186, NULL, NULL, '2022-12-06 10:52:16', NULL, '2022-12-06 10:55:22', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120610554589130005EB2BAD3A0A', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:java.util.LinkedHashMap cannot be cast to cn.hutool.core.lang.Dict', NULL, 63, NULL, NULL, '2022-12-06 10:55:45', NULL, '2022-12-06 10:56:49', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206110239292000DC4ADB7B5A75', 0, 9, '2', 'export', 'D:/excelFile/2022/12/06/20221206110239413000A1CA558B050E.xlsx', NULL, 1, 'excel', NULL, '100%', 108, NULL, NULL, '2022-12-06 11:02:39', NULL, '2022-12-06 11:04:28', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206110505464000E2AE5B13588B', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:java.lang.String cannot be cast to java.util.Map', NULL, 0, NULL, NULL, '2022-12-06 11:05:05', NULL, '2022-12-06 11:05:05', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120611051387600042036B31E071', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:java.lang.String cannot be cast to java.util.Map', NULL, 8, NULL, NULL, '2022-12-06 11:05:13', NULL, '2022-12-06 11:05:22', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206110530828000AE777A14B3A3', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:java.lang.String cannot be cast to java.util.Map', NULL, 28, NULL, NULL, '2022-12-06 11:05:30', NULL, '2022-12-06 11:05:59', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206110730361000BA8DDAD182DB', 0, 9, '-1', 'export', NULL, NULL, 1, 'excel', '生成excel失败:java.lang.String cannot be cast to java.util.Map', NULL, 12, NULL, NULL, '2022-12-06 11:07:30', NULL, '2022-12-06 11:07:42', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120611075882200071CEB0BEEA6A', 0, 9, '2', 'export', 'D:/excelFile/2022/12/06/20221206110758943000864A021A705E.xlsx', NULL, 1, 'excel', NULL, '100%', 15, NULL, NULL, '2022-12-06 11:07:58', NULL, '2022-12-06 11:08:14', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206112200244000E284EDBBEAB4', 0, 9, '2', 'export', 'D:/excelFile/2022/12/06/2022120611220027500018BEAED023ED.xlsx', NULL, 1, 'excel', NULL, '100%', 0, NULL, NULL, '2022-12-06 11:22:00', NULL, '2022-12-06 11:22:00', 'ylt', 'SELECT top 10 * FROM [dbo].[ATTACH]', '{\"sql\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"templateId\":\"9\",\"system\":\"ylt\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206152139705000888D80CCC3EB', 0, 12, '-1', 'export', NULL, NULL, 1, 'excel', '获取sql数据出错或为空', NULL, 0, NULL, NULL, '2022-12-06 15:21:39', NULL, '2022-12-06 15:21:39', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":\"12\",\"system\":\"cim\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206152321456000C8B4371CDDD8', 0, 12, '-1', 'export', NULL, NULL, 1, 'excel', '获取sql数据出错或为空', NULL, 0, NULL, NULL, '2022-12-06 15:23:21', NULL, '2022-12-06 15:23:21', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":\"12\",\"system\":\"cim\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206152402717000D37D3B7CE0C5', 0, 12, '-1', 'export', NULL, NULL, 1, 'excel', '获取sql数据出错或为空', NULL, 17, NULL, NULL, '2022-12-06 15:24:02', NULL, '2022-12-06 15:24:20', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":\"12\",\"system\":\"cim\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212061525142280003ED040E211BB', 0, 12, '2', 'export', 'D:/excelFile/2022/12/06/202212061525234090005457E1CD10D8.xlsx', NULL, 1, 'excel', NULL, '100%', 10, NULL, NULL, '2022-12-06 15:25:14', NULL, '2022-12-06 15:25:24', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":\"12\",\"system\":\"cim\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120615495492100056BCE8D21AD6', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '数据入库出错：只能执行excel文件类型', NULL, 0, NULL, NULL, '2022-12-06 15:49:54', NULL, '2022-12-06 15:49:54', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"\",\"fileName\":\"\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206155004691100CC1E6ABC7EDA', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '数据入库失败：null', NULL, 0, NULL, NULL, '2022-12-06 15:50:04', NULL, '2022-12-07 10:01:45', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206155043921200827E1B7E537D', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '数据入库失败：null', NULL, 0, NULL, NULL, '2022-12-06 15:50:43', NULL, '2022-12-07 10:01:45', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206155334671300AD1E8E63E623', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '数据入库失败：null', NULL, 0, NULL, NULL, '2022-12-06 15:53:34', NULL, '2022-12-07 10:01:45', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212061555244320001CEB8108AE83', 0, NULL, '-1', 'import', NULL, NULL, 1, 'excel', '数据入库出错：数据入库失败：Data truncation: Out of range value for column \'id\' at row 1', NULL, 19, NULL, NULL, '2022-12-06 15:55:24', NULL, '2022-12-06 15:55:43', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206155813563000CCBDD301D1AA', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, '100%', 21, NULL, NULL, '2022-12-06 15:58:13', NULL, '2022-12-06 15:58:34', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206155929224000D52E6DC20AE7', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, '100%', 56, NULL, NULL, '2022-12-06 15:59:29', NULL, '2022-12-06 16:00:26', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212061601320350005DE07A5B8128', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, '9974条', 23, NULL, NULL, '2022-12-06 16:01:32', NULL, '2022-12-06 16:01:55', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221206162114542000AA4AC30CD203', 0, NULL, '2', 'import', NULL, NULL, 1, 'excel', NULL, '9974条', 21, NULL, NULL, '2022-12-06 16:21:14', NULL, '2022-12-06 16:21:35', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"title\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"column\":{\"项目名称\":{\"3\":\"项目3\",\"项目1\":\"xm1\",\"项目2\":\"xm2\"},\"维修名称\":{\"维修1\":\"wx1\",\"3\":\"维修3\",\"维修2\":\"wx2\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212070941028320005DC0E4E6BD8A', 0, 13, '2', 'import', NULL, NULL, 1, 'excel', NULL, '9974条', 23, NULL, NULL, '2022-12-07 09:41:02', NULL, '2022-12-07 09:41:30', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"title\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"column\":{\"项目名称\":{\"3\":\"项目3\",\"项目1\":\"xm1\",\"项目2\":\"xm2\"},\"维修名称\":{\"维修1\":\"wx1\",\"3\":\"维修3\",\"维修2\":\"wx2\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207094405133000B2CCBAEB524A', 0, 13, '2', 'import', NULL, NULL, 1, 'excel', NULL, '9974条', 26, NULL, NULL, '2022-12-07 09:44:05', NULL, '2022-12-07 09:44:33', NULL, NULL, '{\"templateId\":\"13\",\"tableName\":\"gz_data_copy\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"title\":{\"项目名称\":\"ss_name\",\"维修名称\":\"wx_name\"},\"column\":{\"项目名称\":{\"3\":\"项目3\",\"项目1\":\"xm1\",\"项目2\":\"xm2\"},\"维修名称\":{\"维修1\":\"wx1\",\"3\":\"维修3\",\"维修2\":\"wx2\"}},\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100249682000B21EAAC6518D', 0, 13, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-07 10:02:49', NULL, '2022-12-07 10:02:49', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100254043000624DD0E67BE8', 0, 13, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-07 10:02:54', NULL, '2022-12-07 10:02:54', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100255484000B7E4831000C5', 0, 13, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-07 10:02:55', NULL, '2022-12-07 10:02:55', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100257035000B2B7B1DC622B', 0, 13, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-07 10:02:57', NULL, '2022-12-07 10:02:57', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100344586000CCB2E6A07AE2', 0, 13, '-1', 'import', NULL, NULL, 1, 'excel', '导入表为空', NULL, 0, NULL, NULL, '2022-12-07 10:03:44', NULL, '2022-12-07 10:03:44', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100407717000CE0D343BDBC1', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 30, NULL, NULL, '2022-12-07 10:04:07', NULL, '2022-12-07 10:04:38', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071004127080006E24EEAEBCDB', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 27, NULL, NULL, '2022-12-07 10:04:12', NULL, '2022-12-07 10:04:40', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100415019000610EC8567200', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 27, NULL, NULL, '2022-12-07 10:04:15', NULL, '2022-12-07 10:04:42', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071004177610007663DEDAAE61', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 21, NULL, NULL, '2022-12-07 10:04:17', NULL, '2022-12-07 10:05:00', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100636121100BEAAE162C2E1', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 26, NULL, NULL, '2022-12-07 10:06:36', NULL, '2022-12-07 10:07:02', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071006399112000D76C3DE2EA1', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 26, NULL, NULL, '2022-12-07 10:06:39', NULL, '2022-12-07 10:07:06', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207100644421300BD7ABB30C418', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', NULL, '9974条', 26, NULL, NULL, '2022-12-07 10:06:44', NULL, '2022-12-07 10:07:11', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071006475314000DBE0CDB2DA1', 0, 13, '-1', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库失败：The supplied file was empty (zero bytes long)', '9974条', 0, NULL, NULL, '2022-12-07 10:06:47', NULL, '2022-12-07 10:10:27', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071006505115005BC0E077BAD8', 0, 13, '-1', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库失败：The supplied file was empty (zero bytes long)', '9974条', 0, NULL, NULL, '2022-12-07 10:06:50', NULL, '2022-12-07 10:10:27', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071015198720002DEBDBE0DBDB', 0, 13, '-1', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库失败：The supplied file was empty (zero bytes long)', '3000条', 0, NULL, NULL, '2022-12-07 10:15:19', NULL, '2022-12-07 10:16:41', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207101702852000AC055CE16A08', 0, 13, '-1', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库失败：The supplied file was empty (zero bytes long)', NULL, 0, NULL, NULL, '2022-12-07 10:17:02', NULL, '2022-12-07 10:17:03', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207101842612000AA8CC3BE26AA', 0, 13, '-1', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库失败：IOException: Truncated ZIP file', NULL, 0, NULL, NULL, '2022-12-07 10:18:42', NULL, '2022-12-07 10:18:43', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071025397220007DEA33BE0B3C', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '数据入库失败：The supplied file was empty (zero bytes long)', '9974条', 21, NULL, NULL, '2022-12-07 10:25:39', NULL, '2022-12-07 10:32:00', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071030069220000E08C7A238D2', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'excel', '导入成功', '9974条', 21, NULL, NULL, '2022-12-07 10:30:06', NULL, '2022-12-07 10:35:00', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207103520902000B00EEEAB2D0C', 0, 13, '-3', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'xlsx', '主动终止', '5000条', 11, NULL, NULL, '2022-12-07 10:35:20', NULL, '2022-12-07 10:35:33', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('2022120714373557800086CD083D3803', 0, 13, '2', 'import', 'D:/excelFile/2022/12/07/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'xlsx', '导入成功', '9974条', 22, NULL, NULL, '2022-12-07 14:37:35', NULL, '2022-12-07 14:37:58', NULL, NULL, '{\"templateId\":\"13\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212071446287420003A2CB01C7B51', 0, 12, '2', 'export', 'D:/excelFile/2022/12/07/20221207144630843000200C6B427A6A.xlsx', '', 1, 'excel', '导出成功', '100%', 2, NULL, NULL, '2022-12-07 14:46:28', NULL, '2022-12-08 11:46:36', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":\"12\",\"system\":\"cim\",\"pageNumber\":1,\"pageSize\":10,\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221207144950914000C1C4ED8A85DD', 0, 12, '2', 'export', 'D:/excelFile/2022/12/09/2022120908511635300001110BDE8AB1.xlsx', NULL, 1, 'excel', '导出成功', '100%', 1, NULL, NULL, '2022-12-07 14:49:50', NULL, '2022-12-09 08:51:17', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":12,\"system\":\"cim\",\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221208132159992000A7EBBC3CCE4E', NULL, NULL, '-1', 'export', NULL, NULL, 1, NULL, '未获取到模板数据', NULL, 0, NULL, 'admin', '2022-12-08 13:22:00', NULL, '2022-12-09 08:47:52', NULL, NULL, '{\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221208132615462000587CD207BD6A', NULL, 12, '2', 'export', 'D:/excelFile/2022/12/09/20221209092556123000AEC7C7B8BD3C.xlsx', NULL, 1, NULL, '导出成功', '100%', 3, NULL, 'admin', '2022-12-08 13:26:15', NULL, '2022-12-09 09:25:58', 'cim', 'SELECT * FROM damage limit 100', '{\"sql\":\"SELECT * FROM damage limit 100\",\"templateId\":12,\"system\":\"cim\",\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('202212081403550720008BCEE4ACBBDE', NULL, 11, '-3', 'export', NULL, NULL, 1, NULL, '生成excel出错：主动终止', '10%', 11, NULL, 'admin', '2022-12-08 14:03:55', NULL, '2022-12-09 08:56:47', 'ylt_101280101', 'select top 100000 * from damage', '{\"sql\":\"select top 100000 * from damage\",\"templateId\":11,\"system\":\"ylt\",\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221208154306514000E7EAAB08B46A', NULL, 13, '2', 'import', 'D:/excelFile/2022/12/08/2022120516470899110005EDE5BB4C02.xlsx', NULL, 1, 'xlsx', '导入成功', '9974条', 28, NULL, 'admin', '2022-12-08 15:43:07', NULL, '2022-12-08 16:23:53', 'testDb', NULL, '{\"templateId\":13,\"inputStream\":\"sun.net.www.protocol.http.HttpURLConnection$HttpInputStream@69375f8b\",\"fileType\":\"xlsx\",\"fileName\":\"2022120516470899110005EDE5BB4C02.xlsx\",\"params\":{}}');
INSERT INTO `import_export_task` VALUES ('20221209093032104000AC6BC171B2CD', NULL, 1, '2', 'export', 'D:/excelFile/2022/12/09/20221209093032555000863AD2D4525B.xlsx', NULL, 1, NULL, '导出成功', '100%', 0, NULL, 'admin', '2022-12-09 09:30:32', NULL, '2022-12-09 09:30:33', NULL, 'select * from jdbc_config', '{\"sql\":\"select * from jdbc_config\",\"templateId\":1,\"params\":{}}');

-- ----------------------------
-- Table structure for import_export_template
-- ----------------------------
DROP TABLE IF EXISTS `import_export_template`;
CREATE TABLE `import_export_template`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `template_type` int(11) NULL DEFAULT NULL COMMENT '模板类型（1：sql模板，2：excel模板）',
  `file_type` int(11) NULL DEFAULT NULL COMMENT '模板文件类型（1：本地文件，2： oss文件）',
  `file_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '模板文件路径',
  `dict` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '字典映射（标题，列）（json或yaml格式）',
  `style` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '样式（json或yaml格式）',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '备注',
  `isdelete` int(11) NULL DEFAULT NULL COMMENT '是否删除',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `jdbc_config_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '数据库连接配置',
  `table_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '表名（导入时的表）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '导入导出模板' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of import_export_template
-- ----------------------------
INSERT INTO `import_export_template` VALUES (1, 1, NULL, NULL, '', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (2, 2, 2, 'test/template/开挖监管统计表.xlsx', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (3, 2, 2, 'test/template/施工对比照.xlsx', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (4, 2, 2, 'test/template/预览收方汇总表.xlsx', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (5, 2, 1, 'E:/lys/projects/yysExcel/src/main/resources/templates/excel/template/开挖监管统计表.xlsx', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (6, 2, 1, 'E:/lys/projects/yysExcel/src/main/resources/templates/excel/template/施工对比照.xlsx', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (7, 1, NULL, NULL, 'title:\r\n  CCDZ: 存储地址\r\n  CCMC: 存储名称\r\n  WJHZ: 文件后缀\r\n  WJLX: 文件类型\r\n  YSMC: 原始名称\r\n  style: 样式\r\n  add_time: 添加时间\r\ncolumn:\r\n  WJLX:\r\n    \'0\': 文件or图片\r\n    \'1\': 照片\r\n    \'2\': 文件\r\n    \'3\': excel转图片\r\n  WJHZ:\r\n    jpg: jpg图片\r\n    png: png图片\r\n', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (8, 1, NULL, NULL, 'title:\r\n  CCDZ: 存储地址\r\n  CCMC: 存储名称\r\n  WJHZ: 文件后缀\r\n  WJLX: 文件类型\r\n  YSMC: 原始名称\r\n  style: 样式\r\n  add_time: 添加时间\r\ncolumn:\r\n  WJLX:\r\n    \'0\': 文件or图片\r\n    \'1\': 照片\r\n    \'2\': 文件\r\n    \'3\': excel转图片\r\n  WJHZ:\r\n    jpg: jpg图片\r\n    png: png图片\r\n', 'columnWidth:\r\n  \'0\': 10\r\n  \'1\': 15\r\n  \'2\': 20\r\n  \'3\': 25\r\nrowHeigh:\r\n  \'0\': 30\r\n  \'1\': 40\r\n  \'2\': 50\r\n  \'3\': 60\r\nautoSizeColumn:\r\n  - 4\r\n  - 5\r\n  - 6\r\n  - 7\r\n', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (9, 1, NULL, NULL, 'title:\r\n  CCDZ: 存储地址\r\n  CCMC: 存储名称\r\n  WJHZ: 文件后缀\r\n  WJLX: 文件类型\r\n  YSMC: 原始名称\r\n  style: 样式\r\n  add_time: 添加时间\r\ncolumn:\r\n  WJLX:\r\n    \'0\': 文件or图片\r\n    \'1\': 照片\r\n    \'2\': 文件\r\n    \'3\': excel转图片\r\n  WJHZ:\r\n    jpg: jpg图片\r\n    png: png图片\r\n', 'columnWidth:\r\n  \'-1\': 40\r\nrowHeigh:\r\n  \'-1\': 40\r\nmerges:\r\n  - firstRow: 12\r\n    lastRow: 13\r\n    firstColumn: 0\r\n    lastColumn: 1\r\n    content: 第一个合并内容\r\n  - firstRow: 13\r\n    lastRow: 14\r\n    firstColumn: 2\r\n    lastColumn: 5\r\n    content: 第二个合并内容\r\n', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `import_export_template` VALUES (11, 1, NULL, '', 'title:\r\n  CCDZ: 存储地址\r\n  CCMC: 存储名称\r\n  WJHZ: 文件后缀\r\n  WJLX: 文件类型\r\n  YSMC: 原始名称\r\n  style: 样式\r\n  add_time: 添加时间\r\ncolumn:\r\n  WJLX:\r\n    \'0\': 文件or图片\r\n    \'1\': 照片\r\n    \'2\': 文件\r\n    \'3\': excel转图片\r\n  WJHZ:\r\n    jpg: jpg图片\r\n    png: png图片\r\n', NULL, NULL, 0, NULL, NULL, NULL, '2022-12-08 15:44:49', '2022120615174747200074DEACB81AAC', 'gz_data_copy');
INSERT INTO `import_export_template` VALUES (12, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '202212061456540820005BBC14DAC5A3', NULL);
INSERT INTO `import_export_template` VALUES (13, 1, NULL, NULL, 'title:\r\n  项目名称: ss_name\r\n  维修名称: wx_name\r\ncolumn:\r\n  项目名称:\r\n    \'项目1\': xm1\r\n    \'项目2\': xm2\r\n    \'3\': 项目3\r\n  维修名称:\r\n    \'维修1\': wx1\r\n    \'维修2\': wx2\r\n    \'3\': 维修3\r\n', NULL, '导入：mysql-testDb', 0, NULL, NULL, NULL, NULL, '20221206151922004000405BC1AAABCB', 'gz_data_copy');

-- ----------------------------
-- Table structure for jdbc_config
-- ----------------------------
DROP TABLE IF EXISTS `jdbc_config`;
CREATE TABLE `jdbc_config`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '数据库类型',
  `ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'ip',
  `port` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '端口',
  `database_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '数据库名称',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '备注',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `isdelete` int(11) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '数据库连接配置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jdbc_config
-- ----------------------------
INSERT INTO `jdbc_config` VALUES ('202212061456540820005BBC14DAC5A3', 'mysql', '221.199.189.211', '3306', 'cim', 'root', 'ROOT123', 'cim系统', NULL, NULL, NULL, '2022-12-07 15:47:50', 0);
INSERT INTO `jdbc_config` VALUES ('202212061517120020007C85ED30ED38', 'sqlserver', '192.168.1.41', '1433', 'nmcf_yhgl_xcgl', 'sa', 'yysyysyys', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `jdbc_config` VALUES ('2022120615174747200074DEACB81AAC', 'sqlserver', '192.168.1.51', '1433', 'ylt_101280101', 'sa', 'yysyysyys', '广州系统', NULL, NULL, NULL, '2022-12-08 14:00:30', 0);
INSERT INTO `jdbc_config` VALUES ('20221206151814853000E77D13C57D08', 'sqlserver', '192.168.1.243', '1433', 'nmcf_major_bridge', 'sa', 'yysyysyys', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `jdbc_config` VALUES ('20221206151922004000405BC1AAABCB', 'mysql', '192.168.1.51', '3306', 'testDb', 'root', 'root', NULL, NULL, NULL, NULL, '2022-12-07 16:17:08', 0);

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `blob_data` blob NULL COMMENT '存放持久化Trigger对象',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Blob类型的触发器表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '日历名称',
  `calendar` blob NOT NULL COMMENT '存放持久化calendar对象',
  PRIMARY KEY (`sched_name`, `calendar_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '日历信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `cron_expression` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'cron表达式',
  `time_zone_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '时区',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Cron类型的触发器表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `entry_id` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度器实例id',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度器实例名',
  `fired_time` bigint(13) NOT NULL COMMENT '触发的时间',
  `sched_time` bigint(13) NOT NULL COMMENT '定时器制定的时间',
  `priority` int(11) NOT NULL COMMENT '优先级',
  `state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态',
  `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '任务名称',
  `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '任务组名',
  `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否并发',
  `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否接受恢复执行',
  PRIMARY KEY (`sched_name`, `entry_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '已触发的触发器表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
  `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务组名',
  `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '相关介绍',
  `job_class_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '执行任务类名称',
  `is_durable` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '是否持久化',
  `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '是否并发',
  `is_update_data` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '是否更新数据',
  `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '是否接受恢复执行',
  `job_data` blob NULL COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`, `job_name`, `job_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '任务详细信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `lock_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '悲观锁名称',
  PRIMARY KEY (`sched_name`, `lock_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '存储的悲观锁信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  PRIMARY KEY (`sched_name`, `trigger_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '暂停的触发器表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '实例名称',
  `last_checkin_time` bigint(13) NOT NULL COMMENT '上次检查时间',
  `checkin_interval` bigint(13) NOT NULL COMMENT '检查间隔时间',
  PRIMARY KEY (`sched_name`, `instance_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '调度器状态表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `repeat_count` bigint(7) NOT NULL COMMENT '重复的次数统计',
  `repeat_interval` bigint(12) NOT NULL COMMENT '重复的间隔时间',
  `times_triggered` bigint(10) NOT NULL COMMENT '已经触发的次数',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '简单触发器的信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键',
  `str_prop_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第一个参数',
  `str_prop_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第二个参数',
  `str_prop_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第三个参数',
  `int_prop_1` int(11) NULL DEFAULT NULL COMMENT 'int类型的trigger的第一个参数',
  `int_prop_2` int(11) NULL DEFAULT NULL COMMENT 'int类型的trigger的第二个参数',
  `long_prop_1` bigint(20) NULL DEFAULT NULL COMMENT 'long类型的trigger的第一个参数',
  `long_prop_2` bigint(20) NULL DEFAULT NULL COMMENT 'long类型的trigger的第二个参数',
  `dec_prop_1` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数',
  `dec_prop_2` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数',
  `bool_prop_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数',
  `bool_prop_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '同步机制的行锁表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers`  (
  `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调度名称',
  `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '触发器的名字',
  `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '触发器所属组的名字',
  `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_job_details表job_name的外键',
  `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'qrtz_job_details表job_group的外键',
  `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '相关介绍',
  `next_fire_time` bigint(13) NULL DEFAULT NULL COMMENT '上一次触发时间（毫秒）',
  `prev_fire_time` bigint(13) NULL DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）',
  `priority` int(11) NULL DEFAULT NULL COMMENT '优先级',
  `trigger_state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '触发器状态',
  `trigger_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '触发器的类型',
  `start_time` bigint(13) NOT NULL COMMENT '开始时间',
  `end_time` bigint(13) NULL DEFAULT NULL COMMENT '结束时间',
  `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '日程表名称',
  `misfire_instr` smallint(2) NULL DEFAULT NULL COMMENT '补偿执行的策略',
  `job_data` blob NULL COMMENT '存放持久化job对象',
  PRIMARY KEY (`sched_name`, `trigger_name`, `trigger_group`) USING BTREE,
  INDEX `sched_name`(`sched_name`, `job_name`, `job_group`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '触发器详细信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-11-28 09:18:44', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-11-28 09:18:44', '', NULL, '初始化密码 123456');
INSERT INTO `sys_config` VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-11-28 09:18:44', '', NULL, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO `sys_config` VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', '2022-11-28 09:18:44', '', NULL, '是否开启验证码功能（true开启，false关闭）');
INSERT INTO `sys_config` VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-11-28 09:18:44', '', NULL, '是否开启注册用户功能（true开启，false关闭）');

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父部门id',
  `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
  `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (100, 0, '0', '若依科技', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '深圳总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '长沙分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);
INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL);

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data`  (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) NULL DEFAULT 0 COMMENT '字典排序',
  `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '性别男');
INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '性别女');
INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '性别未知');
INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '显示菜单');
INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '默认分组');
INSERT INTO `sys_dict_data` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '系统分组');
INSERT INTO `sys_dict_data` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '系统默认是');
INSERT INTO `sys_dict_data` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '系统默认否');
INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '通知');
INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '公告');
INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '关闭状态');
INSERT INTO `sys_dict_data` VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '其他操作');
INSERT INTO `sys_dict_data` VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '新增操作');
INSERT INTO `sys_dict_data` VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '修改操作');
INSERT INTO `sys_dict_data` VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '删除操作');
INSERT INTO `sys_dict_data` VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '授权操作');
INSERT INTO `sys_dict_data` VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '导出操作');
INSERT INTO `sys_dict_data` VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '导入操作');
INSERT INTO `sys_dict_data` VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '强退操作');
INSERT INTO `sys_dict_data` VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '生成操作');
INSERT INTO `sys_dict_data` VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '清空操作');
INSERT INTO `sys_dict_data` VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (30, 1, 'sql模板', '1', 'template_type', NULL, 'default', 'N', '0', 'admin', '2022-12-08 16:49:51', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (31, 2, 'excel模板', '2', 'template_type', NULL, 'default', 'N', '0', 'admin', '2022-12-08 16:50:05', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (32, 1, '本地文件', '1', 'template_file_type', NULL, 'default', 'N', '0', 'admin', '2022-12-08 16:50:48', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (33, 2, 'oss文件', '2', 'template_file_type', NULL, 'default', 'N', '0', 'admin', '2022-12-08 16:50:56', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (34, 2, '删除', '1', 'isdelete', NULL, 'default', 'N', '0', 'admin', '2022-12-08 16:52:00', 'admin', '2022-12-08 16:52:16', NULL);
INSERT INTO `sys_dict_data` VALUES (35, 1, '存在', '0', 'isdelete', NULL, 'default', 'N', '0', 'admin', '2022-12-08 16:52:10', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (36, 1, '异常', '-1', 'task_status', NULL, 'danger', 'N', '0', 'admin', '2022-12-08 16:53:34', 'admin', '2022-12-08 17:08:49', NULL);
INSERT INTO `sys_dict_data` VALUES (37, 2, '超时', '-2', 'task_status', NULL, 'warning', 'N', '0', 'admin', '2022-12-08 16:53:59', 'admin', '2022-12-08 17:08:57', NULL);
INSERT INTO `sys_dict_data` VALUES (38, 3, '主动终止', '-3', 'task_status', 'el-tag--success', 'default', 'N', '0', 'admin', '2022-12-08 16:54:09', 'admin', '2022-12-08 17:26:21', NULL);
INSERT INTO `sys_dict_data` VALUES (39, 4, '等待执行', '0', 'task_status', NULL, 'info', 'N', '0', 'admin', '2022-12-08 16:54:20', 'admin', '2022-12-08 17:09:18', NULL);
INSERT INTO `sys_dict_data` VALUES (40, 5, '执行中', '1', 'task_status', ':loading=\"true\"', 'primary', 'N', '0', 'admin', '2022-12-08 16:54:32', 'admin', '2022-12-08 17:11:56', NULL);
INSERT INTO `sys_dict_data` VALUES (41, 6, '执行完成', '2', 'task_status', NULL, 'success', 'N', '0', 'admin', '2022-12-08 16:54:43', 'admin', '2022-12-08 17:09:37', NULL);
INSERT INTO `sys_dict_data` VALUES (42, 1, '导入', 'import', 'task_op_type', NULL, 'default', 'N', '0', 'admin', '2022-12-08 17:04:27', 'admin', '2022-12-08 17:08:15', NULL);
INSERT INTO `sys_dict_data` VALUES (43, 2, '导出', 'export', 'task_op_type', NULL, 'default', 'N', '0', 'admin', '2022-12-08 17:04:39', 'admin', '2022-12-08 17:08:18', NULL);
INSERT INTO `sys_dict_data` VALUES (44, 1, '是', '1', 'task_op_async', NULL, 'default', 'N', '0', 'admin', '2022-12-08 17:29:51', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (45, 2, '否', '0', 'task_op_async', NULL, 'default', 'N', '0', 'admin', '2022-12-08 17:30:04', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (46, 1, 'mysql', 'mysql', 'database_type', NULL, 'default', 'N', '0', 'admin', '2022-12-09 09:19:23', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (47, 2, 'sqlserver', 'sqlserver', 'database_type', NULL, 'default', 'N', '0', 'admin', '2022-12-09 09:19:37', 'admin', '2022-12-09 09:21:43', NULL);

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`  (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典类型',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '用户性别列表');
INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '菜单状态列表');
INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '系统开关列表');
INSERT INTO `sys_dict_type` VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '任务状态列表');
INSERT INTO `sys_dict_type` VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '任务分组列表');
INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '系统是否列表');
INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '通知类型列表');
INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '通知状态列表');
INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '操作类型列表');
INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '登录状态列表');
INSERT INTO `sys_dict_type` VALUES (11, '模板类型', 'template_type', '0', 'admin', '2022-12-08 16:49:13', '', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES (12, '模板文件类型', 'template_file_type', '0', 'admin', '2022-12-08 16:50:33', '', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES (13, '是否删除', 'isdelete', '0', 'admin', '2022-12-08 16:51:46', '', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES (14, '任务状态', 'task_status', '0', 'admin', '2022-12-08 16:52:49', '', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES (15, '任务操作类型', 'task_op_type', '0', 'admin', '2022-12-08 17:04:05', '', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES (16, '是否异步', 'task_op_async', '0', 'admin', '2022-12-08 17:29:39', '', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES (17, '数据库类型', 'database_type', '0', 'admin', '2022-12-09 09:18:50', '', NULL, NULL);

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job`  (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`, `job_name`, `job_group`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '定时任务调度表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_job
-- ----------------------------
INSERT INTO `sys_job` VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2022-11-28 09:18:44', '', NULL, '');

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log`  (
  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务组名',
  `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调用目标字符串',
  `job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '日志信息',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '异常信息',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_log_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------

-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
DROP TABLE IF EXISTS `sys_logininfor`;
CREATE TABLE `sys_logininfor`  (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '操作系统',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '提示消息',
  `login_time` datetime NULL DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 129 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
INSERT INTO `sys_logininfor` VALUES (100, 'ry', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '密码输入错误1次', '2022-11-28 09:31:24');
INSERT INTO `sys_logininfor` VALUES (101, 'ry', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '用户不存在/密码错误', '2022-11-28 09:31:24');
INSERT INTO `sys_logininfor` VALUES (102, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '验证码已失效', '2022-11-28 09:33:29');
INSERT INTO `sys_logininfor` VALUES (103, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '用户不存在/密码错误', '2022-11-28 09:33:33');
INSERT INTO `sys_logininfor` VALUES (104, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '密码输入错误1次', '2022-11-28 09:33:33');
INSERT INTO `sys_logininfor` VALUES (105, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-11-28 09:33:46');
INSERT INTO `sys_logininfor` VALUES (106, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '验证码已失效', '2022-12-07 15:17:43');
INSERT INTO `sys_logininfor` VALUES (107, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '用户不存在/密码错误', '2022-12-07 15:17:47');
INSERT INTO `sys_logininfor` VALUES (108, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '1', '密码输入错误1次', '2022-12-07 15:17:47');
INSERT INTO `sys_logininfor` VALUES (109, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-07 15:17:54');
INSERT INTO `sys_logininfor` VALUES (110, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-08 08:40:51');
INSERT INTO `sys_logininfor` VALUES (111, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-12-08 09:10:51');
INSERT INTO `sys_logininfor` VALUES (112, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '密码输入错误1次', '2022-12-08 11:29:39');
INSERT INTO `sys_logininfor` VALUES (113, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '用户不存在/密码错误', '2022-12-08 11:29:39');
INSERT INTO `sys_logininfor` VALUES (114, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '1', '验证码错误', '2022-12-08 11:29:43');
INSERT INTO `sys_logininfor` VALUES (115, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-12-08 11:29:47');
INSERT INTO `sys_logininfor` VALUES (116, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-12-08 13:09:26');
INSERT INTO `sys_logininfor` VALUES (117, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-08 13:55:05');
INSERT INTO `sys_logininfor` VALUES (118, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-08 14:30:49');
INSERT INTO `sys_logininfor` VALUES (119, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-08 15:31:02');
INSERT INTO `sys_logininfor` VALUES (120, 'admin', '127.0.0.1', '内网IP', 'Chrome 9', 'Windows 10', '0', '登录成功', '2022-12-08 15:45:20');
INSERT INTO `sys_logininfor` VALUES (121, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-08 15:45:42');
INSERT INTO `sys_logininfor` VALUES (122, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-08 16:25:45');
INSERT INTO `sys_logininfor` VALUES (123, 'admin', '127.0.0.1', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-09 08:28:33');
INSERT INTO `sys_logininfor` VALUES (124, 'admin', '192.168.1.90', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-09 08:45:41');
INSERT INTO `sys_logininfor` VALUES (125, 'admin', '192.168.1.32', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-09 08:45:58');
INSERT INTO `sys_logininfor` VALUES (126, 'admin', '192.168.1.51', '内网IP', 'Chrome 10', 'Windows 10', '1', '密码输入错误1次', '2022-12-09 13:03:47');
INSERT INTO `sys_logininfor` VALUES (127, 'admin', '192.168.1.51', '内网IP', 'Chrome 10', 'Windows 10', '1', '用户不存在/密码错误', '2022-12-09 13:03:47');
INSERT INTO `sys_logininfor` VALUES (128, 'admin', '192.168.1.51', '内网IP', 'Chrome 10', 'Windows 10', '0', '登录成功', '2022-12-09 13:03:53');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父菜单ID',
  `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '路由参数',
  `is_frame` int(1) NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',
  `is_cache` int(1) NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2032 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2022-11-28 09:18:44', '', NULL, '系统管理目录');
INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2022-11-28 09:18:44', '', NULL, '系统监控目录');
INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2022-11-28 09:18:44', '', NULL, '系统工具目录');
INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2022-11-28 09:18:44', '', NULL, '用户管理菜单');
INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2022-11-28 09:18:44', '', NULL, '角色管理菜单');
INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2022-11-28 09:18:44', '', NULL, '菜单管理菜单');
INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2022-11-28 09:18:44', '', NULL, '部门管理菜单');
INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2022-11-28 09:18:44', '', NULL, '岗位管理菜单');
INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2022-11-28 09:18:44', '', NULL, '字典管理菜单');
INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2022-11-28 09:18:44', '', NULL, '参数设置菜单');
INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2022-11-28 09:18:44', '', NULL, '通知公告菜单');
INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2022-11-28 09:18:44', '', NULL, '日志管理菜单');
INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2022-11-28 09:18:44', '', NULL, '在线用户菜单');
INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2022-11-28 09:18:44', '', NULL, '定时任务菜单');
INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2022-11-28 09:18:44', '', NULL, '数据监控菜单');
INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2022-11-28 09:18:44', '', NULL, '服务监控菜单');
INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2022-11-28 09:18:44', '', NULL, '缓存监控菜单');
INSERT INTO `sys_menu` VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2022-11-28 09:18:44', '', NULL, '缓存列表菜单');
INSERT INTO `sys_menu` VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2022-11-28 09:18:44', '', NULL, '表单构建菜单');
INSERT INTO `sys_menu` VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2022-11-28 09:18:44', '', NULL, '代码生成菜单');
INSERT INTO `sys_menu` VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2022-11-28 09:18:44', '', NULL, '系统接口菜单');
INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2022-11-28 09:18:44', '', NULL, '操作日志菜单');
INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2022-11-28 09:18:44', '', NULL, '登录日志菜单');
INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1004, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1005, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1006, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1007, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1008, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1009, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1010, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1011, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1012, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1013, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1014, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1015, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1016, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1017, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1018, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1019, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1020, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1021, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1022, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1023, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1024, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1025, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1026, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1027, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1028, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1029, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1030, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1031, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1032, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1033, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1034, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1035, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1036, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1037, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1038, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1039, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1040, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1041, '日志导出', 500, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1042, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1043, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1044, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1045, '账户解锁', 501, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1046, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1047, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1048, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1049, '任务查询', 110, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1050, '任务新增', 110, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1051, '任务修改', 110, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1052, '任务删除', 110, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1053, '状态修改', 110, 5, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1054, '任务导出', 110, 6, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1055, '生成查询', 116, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1056, '生成修改', 116, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1057, '生成删除', 116, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1058, '导入代码', 116, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1059, '预览代码', 116, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1060, '生成代码', 116, 6, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2007, '导入导出', 0, 4, 'importExport', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'form', 'admin', '2022-12-07 15:19:11', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2014, '导入导出任务', 2007, 3, 'task', 'importExport/task/index', NULL, 1, 0, 'C', '0', '0', 'importExport:task:list', '#', 'admin', '2022-12-07 15:23:55', 'admin', '2022-12-07 16:35:02', '导入导出任务菜单');
INSERT INTO `sys_menu` VALUES (2015, '导入导出任务查询', 2014, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:task:query', '#', 'admin', '2022-12-07 15:23:55', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2016, '导入导出任务新增', 2014, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:task:add', '#', 'admin', '2022-12-07 15:23:55', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2017, '导入导出任务修改', 2014, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:task:edit', '#', 'admin', '2022-12-07 15:23:55', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2018, '导入导出任务删除', 2014, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:task:remove', '#', 'admin', '2022-12-07 15:23:55', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2019, '导入导出任务导出', 2014, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:task:export', '#', 'admin', '2022-12-07 15:23:55', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2020, '导入导出模板', 2007, 2, 'template', 'importExport/template/index', NULL, 1, 0, 'C', '0', '0', 'importExport:template:list', '#', 'admin', '2022-12-07 15:24:03', 'admin', '2022-12-07 16:35:09', '导入导出模板菜单');
INSERT INTO `sys_menu` VALUES (2021, '导入导出模板查询', 2020, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:template:query', '#', 'admin', '2022-12-07 15:24:03', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2022, '导入导出模板新增', 2020, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:template:add', '#', 'admin', '2022-12-07 15:24:03', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2023, '导入导出模板修改', 2020, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:template:edit', '#', 'admin', '2022-12-07 15:24:03', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2024, '导入导出模板删除', 2020, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:template:remove', '#', 'admin', '2022-12-07 15:24:03', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2025, '导入导出模板导出', 2020, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:template:export', '#', 'admin', '2022-12-07 15:24:03', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2026, '数据原配置', 2007, 1, 'jdbcConfig', 'importExport/jdbcConfig/index', NULL, 1, 0, 'C', '0', '0', 'importExport:jdbcConfig:list', '#', 'admin', '2022-12-07 15:37:19', 'admin', '2022-12-08 13:55:37', '数据库连接配置菜单');
INSERT INTO `sys_menu` VALUES (2027, '数据库连接配置查询', 2026, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:jdbcConfig:query', '#', 'admin', '2022-12-07 15:37:19', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2028, '数据库连接配置新增', 2026, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:jdbcConfig:add', '#', 'admin', '2022-12-07 15:37:19', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2029, '数据库连接配置修改', 2026, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:jdbcConfig:edit', '#', 'admin', '2022-12-07 15:37:19', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2030, '数据库连接配置删除', 2026, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:jdbcConfig:remove', '#', 'admin', '2022-12-07 15:37:19', '', NULL, '');
INSERT INTO `sys_menu` VALUES (2031, '数据库连接配置导出', 2026, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'importExport:jdbcConfig:export', '#', 'admin', '2022-12-07 15:37:19', '', NULL, '');

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice`  (
  `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告标题',
  `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
  `notice_content` longblob NULL COMMENT '公告内容',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`notice_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
INSERT INTO `sys_notice` VALUES (1, '温馨提醒：2018-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2022-11-28 09:18:44', '', NULL, '管理员');
INSERT INTO `sys_notice` VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2022-11-28 09:18:44', '', NULL, '管理员');

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log`  (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '返回参数',
  `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`oper_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 195 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
INSERT INTO `sys_oper_log` VALUES (100, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"import_export_task\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 09:42:57');
INSERT INTO `sys_oper_log` VALUES (101, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/1', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 09:59:02');
INSERT INTO `sys_oper_log` VALUES (102, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"import_export_task\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:00:56');
INSERT INTO `sys_oper_log` VALUES (103, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/2', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:03:09');
INSERT INTO `sys_oper_log` VALUES (104, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"import_export_task\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:03:15');
INSERT INTO `sys_oper_log` VALUES (105, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"task\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":44,\"columnName\":\"id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"IsDelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":45,\"columnName\":\"is_delete\",\"columnType\":\"int(2)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isDelete\",\"javaType\":\"Integer\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":46,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":47,\"columnName\":\"status\",\"columnType\":\"varchar(100)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"status\",\"javaType\":\"String\",\"list\":true,\"params\":{', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:04:12');
INSERT INTO `sys_oper_log` VALUES (106, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createBy\":\"admin\",\"icon\":\"documentation\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"导入导出\",\"menuType\":\"M\",\"orderNum\":4,\"params\":{},\"parentId\":0,\"path\":\"importExport\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:05:03');
INSERT INTO `sys_oper_log` VALUES (107, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createTime\":\"2022-11-28 09:18:44\",\"icon\":\"guide\",\"isCache\":\"0\",\"isFrame\":\"0\",\"menuId\":4,\"menuName\":\"若依官网\",\"menuType\":\"M\",\"orderNum\":5,\"params\":{},\"parentId\":0,\"path\":\"http://ruoyi.vip\",\"perms\":\"\",\"query\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:05:17');
INSERT INTO `sys_oper_log` VALUES (108, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"importExportTask\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":44,\"columnName\":\"id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"updateTime\":\"2022-11-28 10:04:11\",\"usableColumn\":false},{\"capJavaField\":\"IsDelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":45,\"columnName\":\"is_delete\",\"columnType\":\"int(2)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isDelete\",\"javaType\":\"Integer\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"updateTime\":\"2022-11-28 10:04:11\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":46,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":3,\"updateBy\":\"\",\"updateTime\":\"2022-11-28 10:04:11\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":47,\"columnName\":\"status\",\"columnType\":\"varchar(100)\",\"createBy\":\"admin\",\"createTime\":\"2022-11-28 10:03:15\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-11-28 10:06:36');
INSERT INTO `sys_oper_log` VALUES (109, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"import_export_task\"}', NULL, 0, NULL, '2022-11-28 10:06:42');
INSERT INTO `sys_oper_log` VALUES (110, '菜单管理', 1, 'com.ruoyi.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createBy\":\"admin\",\"icon\":\"form\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"导入导出\",\"menuType\":\"M\",\"orderNum\":4,\"params\":{},\"parentId\":0,\"path\":\"importExport\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:19:11');
INSERT INTO `sys_oper_log` VALUES (111, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/3', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:19:27');
INSERT INTO `sys_oper_log` VALUES (112, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"import_export_task,import_export_template,jdbc_config\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:19:35');
INSERT INTO `sys_oper_log` VALUES (113, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"task\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":66,\"columnName\":\"id\",\"columnType\":\"varchar(38)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Isdelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":67,\"columnName\":\"isdelete\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isdelete\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":68,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":69,\"columnName\":\"status\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"radio\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"status\",\"javaType\":\"String\",\"list\":true,\"params', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:21:05');
INSERT INTO `sys_oper_log` VALUES (114, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"template\",\"className\":\"ImportExportTemplate\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":86,\"columnName\":\"id\",\"columnType\":\"bigint(20)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":5,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"TemplateType\",\"columnComment\":\"模板类型（1：sql模板，2：excel模板）\",\"columnId\":87,\"columnName\":\"template_type\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateType\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":5,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"FilePath\",\"columnComment\":\"模板文件路径\",\"columnId\":88,\"columnName\":\"file_path\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"filePath\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":5,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"FileType\",\"columnComment\":\"模板文件类型（1：本地文件，2： oss文件）\",\"columnId\":89,\"columnName\":\"file_type\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"fi', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:21:45');
INSERT INTO `sys_oper_log` VALUES (115, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"jdbcConfig\",\"className\":\"JdbcConfig\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":100,\"columnName\":\"id\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"数据库类型\",\"columnId\":101,\"columnName\":\"type\",\"columnType\":\"varchar(30)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Ip\",\"columnComment\":\"ip\",\"columnId\":102,\"columnName\":\"ip\",\"columnType\":\"varchar(30)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"ip\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Port\",\"columnComment\":\"端口\",\"columnId\":103,\"columnName\":\"port\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"port\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:22:29');
INSERT INTO `sys_oper_log` VALUES (116, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"import_export_task,import_export_template,jdbc_config\"}', NULL, 0, NULL, '2022-12-07 15:22:51');
INSERT INTO `sys_oper_log` VALUES (117, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"jdbcConfig\",\"className\":\"JdbcConfig\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":100,\"columnName\":\"id\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:22:28\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"数据库类型\",\"columnId\":101,\"columnName\":\"type\",\"columnType\":\"varchar(30)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:22:28\",\"usableColumn\":false},{\"capJavaField\":\"Ip\",\"columnComment\":\"ip\",\"columnId\":102,\"columnName\":\"ip\",\"columnType\":\"varchar(30)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"ip\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:22:28\",\"usableColumn\":false},{\"capJavaField\":\"Port\",\"columnComment\":\"端口\",\"columnId\":103,\"columnName\":\"port\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:36:32');
INSERT INTO `sys_oper_log` VALUES (118, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"jdbc_config\"}', NULL, 0, NULL, '2022-12-07 15:36:41');
INSERT INTO `sys_oper_log` VALUES (119, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', NULL, '/tool/gen/synchDb/import_export_task', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:41:51');
INSERT INTO `sys_oper_log` VALUES (120, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"import_export_task\"}', NULL, 0, NULL, '2022-12-07 15:43:42');
INSERT INTO `sys_oper_log` VALUES (121, '数据库连接配置', 2, 'com.ruoyi.yys.controller.JdbcConfigController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/jdbcConfig', '127.0.0.1', '内网IP', '{\"databaseName\":\"cim\",\"id\":\"202212061456540820005BBC14DAC5A3\",\"ip\":\"221.199.189.211\",\"isdelete\":0,\"params\":{},\"port\":\"3306\",\"remark\":\"cim系统\",\"type\":\"mysql\",\"updateTime\":\"2022-12-07 15:47:50.131\",\"userName\":\"root\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 15:47:50');
INSERT INTO `sys_oper_log` VALUES (122, '数据库连接配置', 2, 'com.ruoyi.yys.controller.JdbcConfigController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/jdbcConfig', '127.0.0.1', '内网IP', '{\"databaseName\":\"testDb\",\"id\":\"20221206151922004000405BC1AAABCB\",\"ip\":\"192.168.1.51\",\"isdelete\":0,\"params\":{},\"port\":\"3306\",\"type\":\"mysql\",\"updateTime\":\"2022-12-07 16:16:53.857\",\"userName\":\"root\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 16:16:53');
INSERT INTO `sys_oper_log` VALUES (123, '数据库连接配置', 2, 'com.ruoyi.yys.controller.JdbcConfigController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/jdbcConfig', '127.0.0.1', '内网IP', '{\"databaseName\":\"testDb\",\"id\":\"20221206151922004000405BC1AAABCB\",\"ip\":\"192.168.1.51\",\"isdelete\":0,\"params\":{},\"port\":\"3306\",\"type\":\"mysql\",\"updateTime\":\"2022-12-07 16:17:07.911\",\"userName\":\"root\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 16:17:07');
INSERT INTO `sys_oper_log` VALUES (124, '数据库连接配置', 3, 'com.ruoyi.yys.controller.JdbcConfigController.remove()', 'DELETE', 1, 'admin', NULL, '/importExport/jdbcConfig/2022120713211294200086D44126D43D', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 16:26:07');
INSERT INTO `sys_oper_log` VALUES (125, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"importExport/task/index\",\"createTime\":\"2022-12-07 15:23:55\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2014,\"menuName\":\"导入导出任务\",\"menuType\":\"C\",\"orderNum\":3,\"params\":{},\"parentId\":2007,\"path\":\"task\",\"perms\":\"importExport:task:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 16:35:02');
INSERT INTO `sys_oper_log` VALUES (126, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"importExport/template/index\",\"createTime\":\"2022-12-07 15:24:03\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2020,\"menuName\":\"导入导出模板\",\"menuType\":\"C\",\"orderNum\":2,\"params\":{},\"parentId\":2007,\"path\":\"template\",\"perms\":\"importExport:template:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 16:35:09');
INSERT INTO `sys_oper_log` VALUES (127, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createTime\":\"2022-12-02 18:12:54\",\"executeTime\":\"1\",\"id\":\"2022120218125469300085A31007C4EB\",\"isdelete\":0,\"opAsync\":1,\"opFileName\":\"D:/excelFile/2022/12/02/202212021812547040000E17B0D8EACA.xlsx\",\"opType\":\"export\",\"params\":{},\"progress\":\"100%\",\"sqls\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"status\":\"-3\",\"system\":\"ylt\",\"templateId\":9,\"updateTime\":\"2022-12-07 17:15:32.958\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 17:15:33');
INSERT INTO `sys_oper_log` VALUES (128, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createTime\":\"2022-12-02 18:12:54\",\"executeTime\":\"1\",\"id\":\"2022120218125469300085A31007C4EB\",\"isdelete\":0,\"opAsync\":1,\"opFileName\":\"D:/excelFile/2022/12/02/202212021812547040000E17B0D8EACA.xlsx\",\"opType\":\"export\",\"params\":{},\"progress\":\"100%\",\"sqls\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"status\":\"-2\",\"system\":\"ylt\",\"templateId\":9,\"updateTime\":\"2022-12-07 17:15:44.175\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 17:15:44');
INSERT INTO `sys_oper_log` VALUES (129, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createTime\":\"2022-12-02 18:14:43\",\"executeTime\":\"0\",\"id\":\"202212021814431650005D050E272185\",\"isdelete\":0,\"opAsync\":1,\"opFileName\":\"D:/excelFile/2022/12/02/20221202181443186000BE4214B26414.xlsx\",\"opType\":\"export\",\"params\":{},\"progress\":\"100%\",\"sqls\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"status\":\"-3\",\"system\":\"ylt\",\"templateId\":9,\"updateTime\":\"2022-12-07 17:16:51.919\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 17:16:51');
INSERT INTO `sys_oper_log` VALUES (130, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createTime\":\"2022-12-02 18:16:26\",\"executeTime\":\"0\",\"id\":\"2022120218162667700000C50E3C36C7\",\"isdelete\":0,\"opAsync\":1,\"opFileName\":\"D:/excelFile/2022/12/02/20221202181626698000AAA2A73DBCAB.xlsx\",\"opType\":\"export\",\"params\":{},\"progress\":\"100%\",\"sqls\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"status\":\"0\",\"system\":\"ylt\",\"templateId\":9,\"updateTime\":\"2022-12-07 17:17:30.456\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 17:17:30');
INSERT INTO `sys_oper_log` VALUES (131, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createTime\":\"2022-12-02 18:24:37\",\"executeTime\":\"0\",\"id\":\"202212021824378490000CC3CAC742B8\",\"isdelete\":0,\"opAsync\":1,\"opFileName\":\"D:/excelFile/2022/12/02/20221202182437851000A2DABBEED1DD.xlsx\",\"opType\":\"export\",\"params\":{},\"progress\":\"100%\",\"sqls\":\"SELECT top 10 * FROM [dbo].[ATTACH]\",\"status\":\"1\",\"system\":\"ylt\",\"templateId\":9,\"updateTime\":\"2022-12-07 17:17:52.222\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-07 17:17:52');
INSERT INTO `sys_oper_log` VALUES (132, '导入导出任务', 5, 'com.ruoyi.yys.controller.ImportExportTaskController.export()', 'POST', 1, 'admin', NULL, '/importExport/task/export', '127.0.0.1', '内网IP', '{\"params\":{}}', NULL, 0, NULL, '2022-12-08 09:44:45');
INSERT INTO `sys_oper_log` VALUES (133, '导入导出任务', 5, 'com.ruoyi.yys.controller.ImportExportTaskController.export()', 'POST', 1, 'admin', NULL, '/importExport/task/export', '127.0.0.1', '内网IP', '{\"params\":{}}', NULL, 0, NULL, '2022-12-08 09:48:31');
INSERT INTO `sys_oper_log` VALUES (134, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createTime\":\"2022-12-07 14:46:28\",\"executeTime\":2,\"id\":\"202212071446287420003A2CB01C7B51\",\"isdelete\":0,\"opAsync\":1,\"opDownPath\":\"\",\"opError\":\"导出成功\",\"opFileName\":\"D:/excelFile/2022/12/07/20221207144630843000200C6B427A6A.xlsx\",\"opFileType\":\"excel\",\"opType\":\"export\",\"parameters\":\"{\\\"sql\\\":\\\"SELECT * FROM damage limit 100\\\",\\\"templateId\\\":\\\"12\\\",\\\"system\\\":\\\"cim\\\",\\\"pageNumber\\\":1,\\\"pageSize\\\":10,\\\"params\\\":{}}\",\"params\":{},\"progress\":\"100%\",\"sqls\":\"SELECT * FROM damage limit 100\",\"status\":2,\"system\":\"cim\",\"templateId\":12,\"updateTime\":\"2022-12-08 11:46:36.12\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 11:46:36');
INSERT INTO `sys_oper_log` VALUES (135, '菜单管理', 3, 'com.ruoyi.web.controller.system.SysMenuController.remove()', 'DELETE', 1, 'admin', NULL, '/system/menu/4', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"菜单已分配,不允许删除\",\"code\":601}', 0, NULL, '2022-12-08 13:50:17');
INSERT INTO `sys_oper_log` VALUES (136, '菜单管理', 2, 'com.ruoyi.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"importExport/jdbcConfig/index\",\"createTime\":\"2022-12-07 15:37:19\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2026,\"menuName\":\"数据原配置\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":2007,\"path\":\"jdbcConfig\",\"perms\":\"importExport:jdbcConfig:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 13:55:37');
INSERT INTO `sys_oper_log` VALUES (137, '数据库连接配置', 2, 'com.ruoyi.yys.controller.JdbcConfigController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/jdbcConfig', '127.0.0.1', '内网IP', '{\"databaseName\":\"ylt_101280101\",\"id\":\"2022120615174747200074DEACB81AAC\",\"ip\":\"192.168.1.51\",\"isdelete\":0,\"params\":{},\"port\":\"1433\",\"remark\":\"广州系统\",\"type\":\"sqlserver\",\"updateTime\":\"2022-12-08 14:00:30.423\",\"userName\":\"sa\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 14:00:30');
INSERT INTO `sys_oper_log` VALUES (138, '导入导出模板', 2, 'com.ruoyi.yys.controller.ImportExportTemplateController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/template', '127.0.0.1', '内网IP', '{\"dict\":\"title:\\r\\n  CCDZ: 存储地址\\r\\n  CCMC: 存储名称\\r\\n  WJHZ: 文件后缀\\r\\n  WJLX: 文件类型\\r\\n  YSMC: 原始名称\\r\\n  style: 样式\\r\\n  add_time: 添加时间\\r\\ncolumn:\\r\\n  WJLX:\\r\\n    \'0\': 文件or图片\\r\\n    \'1\': 照片\\r\\n    \'2\': 文件\\r\\n    \'3\': excel转图片\\r\\n  WJHZ:\\r\\n    jpg: jpg图片\\r\\n    png: png图片\\r\\n\",\"filePath\":\"\",\"id\":11,\"isdelete\":0,\"jdbcConfigId\":\"2022120615174747200074DEACB81AAC\",\"params\":{},\"templateType\":1,\"updateTime\":\"2022-12-08 14:21:19.563\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 14:21:19');
INSERT INTO `sys_oper_log` VALUES (139, '导入导出模板', 2, 'com.ruoyi.yys.controller.ImportExportTemplateController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/template', '127.0.0.1', '内网IP', '{\"dict\":\"title:\\r\\n  CCDZ: 存储地址\\r\\n  CCMC: 存储名称\\r\\n  WJHZ: 文件后缀\\r\\n  WJLX: 文件类型\\r\\n  YSMC: 原始名称\\r\\n  style: 样式\\r\\n  add_time: 添加时间\\r\\ncolumn:\\r\\n  WJLX:\\r\\n    \'0\': 文件or图片\\r\\n    \'1\': 照片\\r\\n    \'2\': 文件\\r\\n    \'3\': excel转图片\\r\\n  WJHZ:\\r\\n    jpg: jpg图片\\r\\n    png: png图片\\r\\n\",\"filePath\":\"\",\"id\":11,\"isdelete\":0,\"jdbcConfigId\":\"2022120615174747200074DEACB81AAC\",\"params\":{},\"tableName\":\"gz_data_copy\",\"templateType\":1,\"updateTime\":\"2022-12-08 15:44:48.866\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 15:44:48');
INSERT INTO `sys_oper_log` VALUES (140, '导入导出任务', 2, 'com.ruoyi.yys.controller.ImportExportTaskController.edit()', 'PUT', 1, 'admin', NULL, '/importExport/task', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 15:43:07\",\"executeTime\":3,\"id\":\"20221208154306514000E7EAAB08B46A\",\"opAsync\":1,\"opError\":\"数据入库失败：列名 \'项目名称\' 无效。\",\"opFileName\":\"D:/excelFile/2022/12/08/2022120516470899110005EDE5BB4C02.xlsx\",\"opFileType\":\"xlsx\",\"opType\":\"import\",\"parameters\":\"{\\\"templateId\\\":11,\\\"fileType\\\":\\\"xlsx\\\",\\\"fileName\\\":\\\"2022120516470899110005EDE5BB4C02.xlsx\\\",\\\"params\\\":{}}\",\"params\":{},\"status\":-1,\"templateId\":13,\"updateTime\":\"2022-12-08 15:50:46.333\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 15:50:46');
INSERT INTO `sys_oper_log` VALUES (141, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"模板类型\",\"dictType\":\"template_type\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:49:13');
INSERT INTO `sys_oper_log` VALUES (142, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"sql模板\",\"dictSort\":1,\"dictType\":\"template_type\",\"dictValue\":\"1\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:49:51');
INSERT INTO `sys_oper_log` VALUES (143, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"excel模板\",\"dictSort\":2,\"dictType\":\"template_type\",\"dictValue\":\"2\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:50:06');
INSERT INTO `sys_oper_log` VALUES (144, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"模板文件类型\",\"dictType\":\"template_file_type\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:50:33');
INSERT INTO `sys_oper_log` VALUES (145, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"本地文件\",\"dictSort\":1,\"dictType\":\"template_file_type\",\"dictValue\":\"1\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:50:48');
INSERT INTO `sys_oper_log` VALUES (146, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"oss文件\",\"dictSort\":2,\"dictType\":\"template_file_type\",\"dictValue\":\"2\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:50:56');
INSERT INTO `sys_oper_log` VALUES (147, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"是否删除\",\"dictType\":\"isdelete\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:51:46');
INSERT INTO `sys_oper_log` VALUES (148, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"删除\",\"dictSort\":1,\"dictType\":\"isdelete\",\"dictValue\":\"1\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:52:00');
INSERT INTO `sys_oper_log` VALUES (149, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"存在\",\"dictSort\":1,\"dictType\":\"isdelete\",\"dictValue\":\"0\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:52:10');
INSERT INTO `sys_oper_log` VALUES (150, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:52:00\",\"default\":false,\"dictCode\":34,\"dictLabel\":\"删除\",\"dictSort\":2,\"dictType\":\"isdelete\",\"dictValue\":\"1\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:52:16');
INSERT INTO `sys_oper_log` VALUES (151, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"任务状态\",\"dictType\":\"task_status\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:52:49');
INSERT INTO `sys_oper_log` VALUES (152, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"异常\",\"dictSort\":0,\"dictType\":\"task_status\",\"dictValue\":\"-1\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:53:34');
INSERT INTO `sys_oper_log` VALUES (153, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:53:34\",\"default\":false,\"dictCode\":36,\"dictLabel\":\"异常\",\"dictSort\":1,\"dictType\":\"task_status\",\"dictValue\":\"-1\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:53:43');
INSERT INTO `sys_oper_log` VALUES (154, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"超时\",\"dictSort\":2,\"dictType\":\"task_status\",\"dictValue\":\"-2\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:53:59');
INSERT INTO `sys_oper_log` VALUES (155, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:54:09');
INSERT INTO `sys_oper_log` VALUES (156, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"等待执行\",\"dictSort\":4,\"dictType\":\"task_status\",\"dictValue\":\"0\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:54:20');
INSERT INTO `sys_oper_log` VALUES (157, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"执行中\",\"dictSort\":5,\"dictType\":\"task_status\",\"dictValue\":\"1\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:54:32');
INSERT INTO `sys_oper_log` VALUES (158, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"执行完成\",\"dictSort\":6,\"dictType\":\"task_status\",\"dictValue\":\"2\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:54:43');
INSERT INTO `sys_oper_log` VALUES (159, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"task\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":66,\"columnName\":\"id\",\"columnType\":\"varchar(38)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:41:50\",\"usableColumn\":false},{\"capJavaField\":\"Isdelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":67,\"columnName\":\"isdelete\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isdelete\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:41:50\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":68,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:41:50\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":69,\"columnName\":\"status\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"task_status\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 16:56:49');
INSERT INTO `sys_oper_log` VALUES (160, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"任务操作类型\",\"dictType\":\"task_op_type\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:04:05');
INSERT INTO `sys_oper_log` VALUES (161, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"导入\",\"dictSort\":1,\"dictType\":\"task_op_type\",\"dictValue\":\"import\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:04:27');
INSERT INTO `sys_oper_log` VALUES (162, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"导出\",\"dictSort\":2,\"dictType\":\"task_op_type\",\"dictValue\":\"export\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:04:39');
INSERT INTO `sys_oper_log` VALUES (163, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 17:04:27\",\"default\":false,\"dictCode\":42,\"dictLabel\":\"导入\",\"dictSort\":1,\"dictType\":\"task_op_type\",\"dictValue\":\"import\",\"isDefault\":\"N\",\"listClass\":\"primary\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:04:54');
INSERT INTO `sys_oper_log` VALUES (164, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 17:04:39\",\"default\":false,\"dictCode\":43,\"dictLabel\":\"导出\",\"dictSort\":2,\"dictType\":\"task_op_type\",\"dictValue\":\"export\",\"isDefault\":\"N\",\"listClass\":\"success\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:05:01');
INSERT INTO `sys_oper_log` VALUES (165, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"task\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":66,\"columnName\":\"id\",\"columnType\":\"varchar(38)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 16:56:49\",\"usableColumn\":false},{\"capJavaField\":\"Isdelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":67,\"columnName\":\"isdelete\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isdelete\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 16:56:49\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":68,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 16:56:49\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":69,\"columnName\":\"status\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"task_status\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:05:18');
INSERT INTO `sys_oper_log` VALUES (166, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 17:04:27\",\"default\":false,\"dictCode\":42,\"dictLabel\":\"导入\",\"dictSort\":1,\"dictType\":\"task_op_type\",\"dictValue\":\"import\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:08:15');
INSERT INTO `sys_oper_log` VALUES (167, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 17:04:39\",\"default\":false,\"dictCode\":43,\"dictLabel\":\"导出\",\"dictSort\":2,\"dictType\":\"task_op_type\",\"dictValue\":\"export\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:08:18');
INSERT INTO `sys_oper_log` VALUES (168, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:53:34\",\"default\":false,\"dictCode\":36,\"dictLabel\":\"异常\",\"dictSort\":1,\"dictType\":\"task_status\",\"dictValue\":\"-1\",\"isDefault\":\"N\",\"listClass\":\"danger\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:08:49');
INSERT INTO `sys_oper_log` VALUES (169, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:53:59\",\"default\":false,\"dictCode\":37,\"dictLabel\":\"超时\",\"dictSort\":2,\"dictType\":\"task_status\",\"dictValue\":\"-2\",\"isDefault\":\"N\",\"listClass\":\"warning\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:08:57');
INSERT INTO `sys_oper_log` VALUES (170, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"style=\\\"background-color: #FFC0CB;\\\"\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:09:08');
INSERT INTO `sys_oper_log` VALUES (171, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:20\",\"default\":false,\"dictCode\":39,\"dictLabel\":\"等待执行\",\"dictSort\":4,\"dictType\":\"task_status\",\"dictValue\":\"0\",\"isDefault\":\"N\",\"listClass\":\"info\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:09:18');
INSERT INTO `sys_oper_log` VALUES (172, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:43\",\"default\":false,\"dictCode\":41,\"dictLabel\":\"执行完成\",\"dictSort\":6,\"dictType\":\"task_status\",\"dictValue\":\"2\",\"isDefault\":\"N\",\"listClass\":\"success\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:09:37');
INSERT INTO `sys_oper_log` VALUES (173, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"background-color: #FFC0CB\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:09:51');
INSERT INTO `sys_oper_log` VALUES (174, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"#FFC0CB\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:11:05');
INSERT INTO `sys_oper_log` VALUES (175, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"style=\\\"background-color: #FFC0CB\\\"\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:11:26');
INSERT INTO `sys_oper_log` VALUES (176, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:32\",\"cssClass\":\":loading=\\\"true\\\"\",\"default\":false,\"dictCode\":40,\"dictLabel\":\"执行中\",\"dictSort\":5,\"dictType\":\"task_status\",\"dictValue\":\"1\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:11:43');
INSERT INTO `sys_oper_log` VALUES (177, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:32\",\"cssClass\":\":loading=\\\"true\\\"\",\"default\":false,\"dictCode\":40,\"dictLabel\":\"执行中\",\"dictSort\":5,\"dictType\":\"task_status\",\"dictValue\":\"1\",\"isDefault\":\"N\",\"listClass\":\"primary\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:11:56');
INSERT INTO `sys_oper_log` VALUES (178, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"background-color: #FFC0CB\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:17:01');
INSERT INTO `sys_oper_log` VALUES (179, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"el-tag el-tag--success el-tag--medium el-tag--light\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:24:52');
INSERT INTO `sys_oper_log` VALUES (180, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"el-tag--success\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:26:01');
INSERT INTO `sys_oper_log` VALUES (181, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-08 16:54:09\",\"cssClass\":\"el-tag--success\",\"default\":false,\"dictCode\":38,\"dictLabel\":\"主动终止\",\"dictSort\":3,\"dictType\":\"task_status\",\"dictValue\":\"-3\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:26:21');
INSERT INTO `sys_oper_log` VALUES (182, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"是否异步\",\"dictType\":\"task_op_async\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:29:39');
INSERT INTO `sys_oper_log` VALUES (183, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"是\",\"dictSort\":1,\"dictType\":\"task_op_async\",\"dictValue\":\"1\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:29:51');
INSERT INTO `sys_oper_log` VALUES (184, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"否\",\"dictSort\":2,\"dictType\":\"task_op_async\",\"dictValue\":\"0\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:30:05');
INSERT INTO `sys_oper_log` VALUES (185, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"task\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":66,\"columnName\":\"id\",\"columnType\":\"varchar(38)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 17:05:18\",\"usableColumn\":false},{\"capJavaField\":\"Isdelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":67,\"columnName\":\"isdelete\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isdelete\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 17:05:18\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":68,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 17:05:18\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":69,\"columnName\":\"status\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"task_status\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:30:50');
INSERT INTO `sys_oper_log` VALUES (186, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"task\",\"className\":\"ImportExportTask\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":66,\"columnName\":\"id\",\"columnType\":\"varchar(38)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 17:30:49\",\"usableColumn\":false},{\"capJavaField\":\"Isdelete\",\"columnComment\":\"是否逻辑删除（  1：删除  0：正常）\",\"columnId\":67,\"columnName\":\"isdelete\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"isdelete\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 17:30:49\",\"usableColumn\":false},{\"capJavaField\":\"TemplateId\",\"columnComment\":\"模板id\",\"columnId\":68,\"columnName\":\"template_id\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":4,\"updateBy\":\"\",\"updateTime\":\"2022-12-08 17:30:49\",\"usableColumn\":false},{\"capJavaField\":\"Status\",\"columnComment\":\"数据状态\",\"columnId\":69,\"columnName\":\"status\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:34\",\"dictType\":\"task_status\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-08 17:31:00');
INSERT INTO `sys_oper_log` VALUES (187, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"template\",\"className\":\"ImportExportTemplate\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":86,\"columnName\":\"id\",\"columnType\":\"bigint(20)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":5,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:21:45\",\"usableColumn\":false},{\"capJavaField\":\"TemplateType\",\"columnComment\":\"模板类型（1：sql模板，2：excel模板）\",\"columnId\":87,\"columnName\":\"template_type\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"template_type\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"templateType\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":5,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:21:45\",\"usableColumn\":false},{\"capJavaField\":\"FilePath\",\"columnComment\":\"模板文件路径\",\"columnId\":88,\"columnName\":\"file_path\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"filePath\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":5,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:21:45\",\"usableColumn\":false},{\"capJavaField\":\"FileType\",\"columnComment\":\"模板文件类型（1：本地文件，2： oss文件）\",\"columnId\":89,\"columnName\":\"file_type\",\"columnType\":\"int(11)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"template_file_type\",\"edit\":true,\"htmlType\":\"sel', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 08:48:26');
INSERT INTO `sys_oper_log` VALUES (188, '数据库连接配置', 1, 'com.ruoyi.yys.controller.JdbcConfigController.add()', 'POST', 1, 'admin', NULL, '/importExport/jdbcConfig', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-09 09:18:09.063\",\"databaseName\":\"123\",\"id\":\"202212090918090620003667DE5ED65C\",\"ip\":\"fsdf\",\"params\":{},\"port\":\"123\",\"userName\":\"123\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:18:09');
INSERT INTO `sys_oper_log` VALUES (189, '数据库连接配置', 3, 'com.ruoyi.yys.controller.JdbcConfigController.remove()', 'DELETE', 1, 'admin', NULL, '/importExport/jdbcConfig/202212090918090620003667DE5ED65C', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:18:18');
INSERT INTO `sys_oper_log` VALUES (190, '字典类型', 1, 'com.ruoyi.web.controller.system.SysDictTypeController.add()', 'POST', 1, 'admin', NULL, '/system/dict/type', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"dictName\":\"数据库类型\",\"dictType\":\"database_type\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:18:50');
INSERT INTO `sys_oper_log` VALUES (191, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"mysql\",\"dictSort\":1,\"dictType\":\"database_type\",\"dictValue\":\"mysql\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:19:23');
INSERT INTO `sys_oper_log` VALUES (192, '字典数据', 1, 'com.ruoyi.web.controller.system.SysDictDataController.add()', 'POST', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"default\":false,\"dictLabel\":\"sqlServer\",\"dictSort\":2,\"dictType\":\"database_type\",\"dictValue\":\"sqlServer\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:19:37');
INSERT INTO `sys_oper_log` VALUES (193, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"jdbcConfig\",\"className\":\"JdbcConfig\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"主键\",\"columnId\":100,\"columnName\":\"id\",\"columnType\":\"varchar(32)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"String\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:36:31\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"数据库类型\",\"columnId\":101,\"columnName\":\"type\",\"columnType\":\"varchar(30)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"database_type\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:36:31\",\"usableColumn\":false},{\"capJavaField\":\"Ip\",\"columnComment\":\"ip\",\"columnId\":102,\"columnName\":\"ip\",\"columnType\":\"varchar(30)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"ip\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":6,\"updateBy\":\"\",\"updateTime\":\"2022-12-07 15:36:32\",\"usableColumn\":false},{\"capJavaField\":\"Port\",\"columnComment\":\"端口\",\"columnId\":103,\"columnName\":\"port\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2022-12-07 15:19:35\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\"', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:19:51');
INSERT INTO `sys_oper_log` VALUES (194, '字典数据', 2, 'com.ruoyi.web.controller.system.SysDictDataController.edit()', 'PUT', 1, 'admin', NULL, '/system/dict/data', '127.0.0.1', '内网IP', '{\"createBy\":\"admin\",\"createTime\":\"2022-12-09 09:19:37\",\"default\":false,\"dictCode\":47,\"dictLabel\":\"sqlserver\",\"dictSort\":2,\"dictType\":\"database_type\",\"dictValue\":\"sqlserver\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2022-12-09 09:21:44');

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post`  (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_post
-- ----------------------------
INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2022-11-28 09:18:44', '', NULL, '');
INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2022-11-28 09:18:44', '', NULL, '');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '部门树选择项是否关联显示',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '超级管理员');
INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2022-11-28 09:18:44', '', NULL, '普通角色');

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
INSERT INTO `sys_role_dept` VALUES (2, 100);
INSERT INTO `sys_role_dept` VALUES (2, 101);
INSERT INTO `sys_role_dept` VALUES (2, 105);

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (2, 1);
INSERT INTO `sys_role_menu` VALUES (2, 2);
INSERT INTO `sys_role_menu` VALUES (2, 3);
INSERT INTO `sys_role_menu` VALUES (2, 4);
INSERT INTO `sys_role_menu` VALUES (2, 100);
INSERT INTO `sys_role_menu` VALUES (2, 101);
INSERT INTO `sys_role_menu` VALUES (2, 102);
INSERT INTO `sys_role_menu` VALUES (2, 103);
INSERT INTO `sys_role_menu` VALUES (2, 104);
INSERT INTO `sys_role_menu` VALUES (2, 105);
INSERT INTO `sys_role_menu` VALUES (2, 106);
INSERT INTO `sys_role_menu` VALUES (2, 107);
INSERT INTO `sys_role_menu` VALUES (2, 108);
INSERT INTO `sys_role_menu` VALUES (2, 109);
INSERT INTO `sys_role_menu` VALUES (2, 110);
INSERT INTO `sys_role_menu` VALUES (2, 111);
INSERT INTO `sys_role_menu` VALUES (2, 112);
INSERT INTO `sys_role_menu` VALUES (2, 113);
INSERT INTO `sys_role_menu` VALUES (2, 114);
INSERT INTO `sys_role_menu` VALUES (2, 115);
INSERT INTO `sys_role_menu` VALUES (2, 116);
INSERT INTO `sys_role_menu` VALUES (2, 117);
INSERT INTO `sys_role_menu` VALUES (2, 500);
INSERT INTO `sys_role_menu` VALUES (2, 501);
INSERT INTO `sys_role_menu` VALUES (2, 1000);
INSERT INTO `sys_role_menu` VALUES (2, 1001);
INSERT INTO `sys_role_menu` VALUES (2, 1002);
INSERT INTO `sys_role_menu` VALUES (2, 1003);
INSERT INTO `sys_role_menu` VALUES (2, 1004);
INSERT INTO `sys_role_menu` VALUES (2, 1005);
INSERT INTO `sys_role_menu` VALUES (2, 1006);
INSERT INTO `sys_role_menu` VALUES (2, 1007);
INSERT INTO `sys_role_menu` VALUES (2, 1008);
INSERT INTO `sys_role_menu` VALUES (2, 1009);
INSERT INTO `sys_role_menu` VALUES (2, 1010);
INSERT INTO `sys_role_menu` VALUES (2, 1011);
INSERT INTO `sys_role_menu` VALUES (2, 1012);
INSERT INTO `sys_role_menu` VALUES (2, 1013);
INSERT INTO `sys_role_menu` VALUES (2, 1014);
INSERT INTO `sys_role_menu` VALUES (2, 1015);
INSERT INTO `sys_role_menu` VALUES (2, 1016);
INSERT INTO `sys_role_menu` VALUES (2, 1017);
INSERT INTO `sys_role_menu` VALUES (2, 1018);
INSERT INTO `sys_role_menu` VALUES (2, 1019);
INSERT INTO `sys_role_menu` VALUES (2, 1020);
INSERT INTO `sys_role_menu` VALUES (2, 1021);
INSERT INTO `sys_role_menu` VALUES (2, 1022);
INSERT INTO `sys_role_menu` VALUES (2, 1023);
INSERT INTO `sys_role_menu` VALUES (2, 1024);
INSERT INTO `sys_role_menu` VALUES (2, 1025);
INSERT INTO `sys_role_menu` VALUES (2, 1026);
INSERT INTO `sys_role_menu` VALUES (2, 1027);
INSERT INTO `sys_role_menu` VALUES (2, 1028);
INSERT INTO `sys_role_menu` VALUES (2, 1029);
INSERT INTO `sys_role_menu` VALUES (2, 1030);
INSERT INTO `sys_role_menu` VALUES (2, 1031);
INSERT INTO `sys_role_menu` VALUES (2, 1032);
INSERT INTO `sys_role_menu` VALUES (2, 1033);
INSERT INTO `sys_role_menu` VALUES (2, 1034);
INSERT INTO `sys_role_menu` VALUES (2, 1035);
INSERT INTO `sys_role_menu` VALUES (2, 1036);
INSERT INTO `sys_role_menu` VALUES (2, 1037);
INSERT INTO `sys_role_menu` VALUES (2, 1038);
INSERT INTO `sys_role_menu` VALUES (2, 1039);
INSERT INTO `sys_role_menu` VALUES (2, 1040);
INSERT INTO `sys_role_menu` VALUES (2, 1041);
INSERT INTO `sys_role_menu` VALUES (2, 1042);
INSERT INTO `sys_role_menu` VALUES (2, 1043);
INSERT INTO `sys_role_menu` VALUES (2, 1044);
INSERT INTO `sys_role_menu` VALUES (2, 1045);
INSERT INTO `sys_role_menu` VALUES (2, 1046);
INSERT INTO `sys_role_menu` VALUES (2, 1047);
INSERT INTO `sys_role_menu` VALUES (2, 1048);
INSERT INTO `sys_role_menu` VALUES (2, 1049);
INSERT INTO `sys_role_menu` VALUES (2, 1050);
INSERT INTO `sys_role_menu` VALUES (2, 1051);
INSERT INTO `sys_role_menu` VALUES (2, 1052);
INSERT INTO `sys_role_menu` VALUES (2, 1053);
INSERT INTO `sys_role_menu` VALUES (2, 1054);
INSERT INTO `sys_role_menu` VALUES (2, 1055);
INSERT INTO `sys_role_menu` VALUES (2, 1056);
INSERT INTO `sys_role_menu` VALUES (2, 1057);
INSERT INTO `sys_role_menu` VALUES (2, 1058);
INSERT INTO `sys_role_menu` VALUES (2, 1059);
INSERT INTO `sys_role_menu` VALUES (2, 1060);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '手机号码',
  `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密码',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 103, 'admin', '若依', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '192.168.1.51', '2022-12-09 13:03:53', 'admin', '2022-11-28 09:18:44', '', '2022-12-09 13:03:53', '管理员');
INSERT INTO `sys_user` VALUES (2, 105, 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-11-28 09:18:44', 'admin', '2022-11-28 09:18:44', '', NULL, '测试员');

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`, `post_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
INSERT INTO `sys_user_post` VALUES (1, 1);
INSERT INTO `sys_user_post` VALUES (2, 2);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (1, 1);
INSERT INTO `sys_user_role` VALUES (2, 2);

SET FOREIGN_KEY_CHECKS = 1;
